Home : Bytes IT Community / View Full Version : PostgreSQL

Pages : 1 2 3 4 5 6 [7] 8 9

  1. Seeking concise PL/pgSQL syntax diagram
  2. 7.4RC2 vs 7.4
  3. AUTOCOMMIT didn't work...
  4. SQL text of view
  5. Better Unilization of Memory
  6. unix_socket_directory not fully recognized by pg_ctl?
  7. Query Planner Filtering Of Specified Value From 'On Distinct' Clause
  8. problem running postmaster
  9. indexing with lower(...) -> queries are not optimised very well - Please Help
  10. Lock questions
  11. 7.4RC2 --> 7.4
  12. support
  13. Debian packages of 7.4
  14. pgAdmin3 [pgAdminIII] installation SUSE9
  15. Array syntax
  16. Error during check
  17. Quoting Problem in PLPGSQL
  18. how to get historical data?
  19. PLPGSQL Returning Records
  20. building 7.4 with plperl
  21. Detaching from controlling terminal
  22. Stuck processes, viewing the queries inside
  23. tracking down temp files
  24. SuSE RPMs available for PostgreSQL 7.4
  25. PostgreSQL v7.4 Released
  26. snort, acid and postgres
  27. pg_constraint missing many entries?
  28. MultiByte Columns?
  29. Move a table to another schema
  30. Take a minute to make yourself heard ... (PostgreSQL vs ...)
  31. Alternative cluster location
  32. Market Research on Open Source Database Management Software?
  33. MultiByte columns
  34. Retoring non-administrative user databases
  35. how to find version?
  36. vacuum from ecpg
  37. Help with quote escaping in plpgsql
  38. Grant alter privileges
  39. What are these files about?
  40. Updated Documentation
  41. UPGRADING 7.1 TO 7.3.4
  42. Storage consumption
  43. about serial
  44. Can Postgresql run under Windows?
  45. Loggin SQL Statements from JBOSS/JDBC
  46. Conservation of OIDs
  47. Error on initdb with 7.4RC2
  48. Restoring From pg_dumpall (SOLVED)
  49. Restoring From pg_dumpall
  50. GUIDs
  51. Database Corruption ?
  52. Determine if a string is digit
  53. 64 bit compile on Linux SPARC U5
  54. More Praise! 7.4
  55. DOMAIN usability
  56. Curious about exclusive table locks
  57. embedded postgresql
  58. plpgsql return setof integer?
  59. PL/PGSQL functions suddenly not working
  60. how can I change a btree index into a hash index?
  61. serial type vs. sequences
  62. pl/perl function life and variable scope - concurrency problem?
  63. using NOLOCK cause Cartesian joins
  64. dumping sequences
  65. Column Sizes
  66. Perfomance difference between 7.2 and 7.3
  67. Problem with FKEYS
  68. plperl/createlang issue
  69. Failure of make for 7.3.4 on Mac OS 10.3 Panther
  70. More Praise for 7.4RC2
  71. update slow
  72. change conndeferrable in pg_constraint?
  73. PGexec dumps core at pqResultAlloc
  74. Postgre Architecture
  75. procpid in pg_stat_activity but no correspoding backend
  76. Locks information
  77. Proposal for a cascaded master-slave replication system
  78. Functional index definition
  79. RHEL
  80. Changing xml in a database
  81. multibyte support
  82. Problem with create index
  83. ALTER TABLE ADD UNIQUE .....
  84. psql version mismatch
  85. PostgreSQL v7.4 Release Candidate 2
  86. PL/Perl returning multiple rows
  87. Try internet update from MS
  88. [off-topic] Bugtracker using PostgreSQL
  89. Two build problems - openssl and plperl on RedHat
  90. Visual C++ and Postgres
  91. case-sensitive sorting and locale settings?
  92. Dynamic expression evaluation
  93. PGSQL technical documentation
  94. PL/PGSQL help for getting number of rows matched.
  95. starting the server at boot
  96. drop user question
  97. Problem Deleting Referenced records
  98. Tables spanning db's in cluster
  99. disk access measurment
  100. FrontRange GoldMine w/ PostgreSQL
  101. Questions from a beginner!
  102. Question on Select
  103. SQL-question: returning the id of an insert querry
  104. Tools are disabled, except connect & disconnect
  105. Problem in restoring data
  106. Converting SQL-ASCII encoding database to UNICODE
  107. Help With date/time
  108. performance: time & disk access measurment
  109. Question on Replication
  110. BUG?
  111. postgresql ODBC for Windows!
  112. PostgreSQL, Postgre and Apple
  113. pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'
  114. Problem creating ROWTYPE variable in plpgsql.
  115. Referencing columns from system tables possible?
  116. why does explain tell me I'm using a seq scan?
  117. regarding constant values
  118. phpPGAdmin Indexes, what does this do?
  119. Temp rows - is it possible?
  120. German mailing list
  121. Visio Like Tool....
  122. error when creating rule
  123. DDL for a single schema
  124. Changing the buffer size
  125. Database of electoral results?
  126. on connect trigger?
  127. on connect trigger
  128. int8 primary keys still not using index without manual JDBC driverpatch (7.4RC1)
  129. pg_stat_activity
  130. Optimiser desicion bringing system to its knees?
  131. create function for trigger question
  132. pid of current session?
  133. Insert and obtain the pk
  134. Install files for version 7.4
  135. Default user after upgrade to 7.3?
  136. Fixed column format data
  137. New eRServer patch/fork release
  138. INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE COLUMNS
  139. Sequences without blank holes
  140. Problems with PLPGSQL
  141. PostgreSQL v7.4 Release Candidate 1 compile errors
  142. SQL_ASCII encoding
  143. Select for update and locking problem
  144. Multi-master asynchronous replication
  145. tsearch2 and gist index bloat
  146. Getting time from date field
  147. Question on database structure
  148. Database Design & Application Server Design
  149. invalid command \
  150. How to store pg_constraint's int2[] data type in C++
  151. How to know column constraints via system catalog tables
  152. System crash and trying to run vacuum getting errors
  153. SET AUTOCOMMIT OFF
  154. select/update performance?
  155. Changes in Rel. 7.4
  156. Calculating default values on insert?
  157. access linux command from SQL Query
  158. Using SUBSELECT in CHECK expressions
  159. Foreign Key to Inherited table
  160. PostgreSQL v7.4 Release Candidate 1
  161. Problem with Pg_dumpall
  162. Databases with different encodings
  163. Very strange selectproblem
  164. pg7.3.4: pg_atoi: zero-length string
  165. SELECT question
  166. now() problem
  167. Obtain boolean value of expression in PLPGSQL
  168. Query to pg_stat_activity
  169. C functions quicker than Plpgsql?
  170. transposed query?
  171. question
  172. How to use dblink within pl/pgsql function:
  173. Internet based database
  174. slow down on UPDATE using IN statements
  175. plpgsql question
  176. Please help
  177. PostgreSQL License Question
  178. IF EXISTS?
  179. How to set up a table where 2 columns together must be unique?
  180. Install that security package from Microsoft
  181. AS operator and subselect result names: PostgreSQL vs. Oracle
  182. further ino on bigint index and vacuum issues?
  183. Request for Interview Candidates - PG Research Help
  184. COPY
  185. Altering columns order
  186. help from Portugal
  187. trim(ing) during load process
  188. org.postgresql.PG_Stream.flush(PG_Stream.java:356)
  189. Where are the database files located?
  190. Attribute 'rtrim' is repeated
  191. table locking.. FK tables locking on insert
  192. Pictures from LinuxWorld Expo in Frankfurt
  193. problem with huge joins
  194. Problem with ecpg
  195. Error Messages / Codes in DBD / JDBC
  196. ALTER Table
  197. ATA disks and RAID controllers for database servers
  198. insert data of composite type
  199. Table Copy/Synchronization
  200. DBD::Pg Err / Errstr
  201. Trigger or Rule ?
  202. Tsearch2 indexing question....
  203. Best Perl Option?
  204. database speed
  205. Need Italian Help!
  206. regular backups - super user
  207. formatting of SQL sent by PHP to postgres
  208. slow query performance
  209. Sending email from PL/pgsql
  210. tsearch ukrainian stemmer dict
  211. nextgencms
  212. sql trees move some element
  213. INSERT performance
  214. duplicates rejected by index reports PGSQL_FATAL_ERROR
  215. pg_ctl vs full restart
  216. Statistics on database structure changes
  217. dump schema schema only?
  218. Trigger delete
  219. backup another server
  220. pgAdmin vs SQL Server Enterprise Manager
  221. Database design question: ugliness or referential integrity?
  222. Cartesian product bug?
  223. N Texas PostgreSQL Consultant Needed
  224. Error size varchar
  225. selecting information from two tables (problem)
  226. Help on update that subselects other records in table, uses joins
  227. PG_RESTORE/DUMP Question
  228. Performace question
  229. JDBC DatabaseMetaData problem
  230. Viewing linked large postgres tables with Access: Running out of memory
  231. Versioning control in PostgreSQL?
  232. SELECT with row>32k hangs over SSL-Connection
  233. Stored procedures from MS Query
  234. retrieve statement from catalogs
  235. unsubscribe
  236. What is an RT index?
  237. Multiple database services and multiple versions on Red Hat Linuxsystems
  238. sequences: cache_value, log_cnt, is_cycled columns
  239. connectby
  240. Queuing in Post
  241. Replication again
  242. table functions + user defined types
  243. function with tablename parameter
  244. Experience with PL/xx?
  245. Slow query
  246. foxpro to postgresql7.1
  247. Question about the Internals
  248. can't get tcl installed properly
  249. Retrieving a column comment
  250. Question regarding Perl, DBI, and fork()
  251. Casing: bug?
  252. Problems using PGAdmin III
  253. Slow performance with no apparent reason
  254. incrementing and decrementing dates by day increments programmatically
  255. explicit casting required for index use
  256. no records returned
  257. Performance failure / automatic restart / cron ?
  258. interesting quote...
  259. DBD::PgPP::CursorResponse
  260. partitioning
  261. where to find minor release info
  262. ./configure error - readline library not found
  263. extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax
  264. Index Usage Question
  265. Timestamp and interval precision
  266. shared memory on OS X - 7.4beta4
  267. ERROR: Multiple assignments to same attribute... ??
  268. FW: Check the patch from MS Corporation
  269. Desperate help needed for Replication
  270. Hierarchical query's
  271. Clustering for performance and fail over
  272. HTML generation with PL/PgSQL
  273. CLUSTER
  274. Nullable 'Foreign Key-like' Constraint
  275. Setting up DSPACE for Postgres access
  276. Timestamps in Views
  277. PostgreSQL v7.4 Beta5 Available for Testing
  278. Indexes and querys
  279. database files
  280. Adding fields on the fly
  281. setArray
  282. Prepared Statements
  283. plpgsql extract epoch problem
  284. SCSI vs. IDE performance test
  285. Atrybutes ???
  286. poor cpu utilization on dual cpu box
  287. (NONE)
  288. Trigger
  289. Identifier max length
  290. Postgreqsl & Package
  291. Same conditions, different planning?
  292. unexpected query behavior with UTF text
  293. where is pg_views
  294. Cast result set of select into an array for a sub select...
  295. pg_clog / pg_xlog corruption?
  296. Proposed structure for coexisting major versions
  297. max() over some rows but grouped, within one view def - how ?
  298. DBDesigner for Linux
  299. Simple SQL
  300. About TSearch2 Performance
  301. jboss postgresql pk generation
  302. lastval(seq) ?
  303. create triggers.
  304. pgsql error - situation update
  305. (no subject)
  306. Pgsql 7.3.3 on redhat 7.2
  307. Pgsql 7.3.3 on redhat 7.2 machin
  308. postgres 7.3.3 on redhat 7.2
  309. how to use pg_resetxlog
  310. tsearch2 and aspell
  311. Recomended FS
  312. Quick quote for Install
  313. Numeric type
  314. Cannot create new link. Too many open links
  315. tsearch2 question...
  316. Dilbert Experiences a 'Database Manager' moment
  317. convert string function and built-in conversions
  318. plpgsql
  319. Timestamp to date conversion...plz help me
  320. 7.4b4 domain usage and select question
  321. plpgsql: return multiple result sets
  322. How to quote text before inserting into database?
  323. Postgres seems to BE on windowsXP
  324. using cygwin for postgres
  325. How to activate error messages in my language
  326. Difference between check and a small table
  327. selecting table at execution with PL/PgSQL
  328. Help or Bug?
  329. restart and postgres.conf
  330. Using subselects in INSERTs?
  331. Perl and Postgres
  332. basic question
  333. ecpg and blob's
  334. connecting to external database tables outside of the postgres database
  335. XOR logical operator
  336. Disabling referential integrity
  337. pg_atoi
  338. Remote updating
  339. maximum number of client connections?
  340. problem with function to report how many records were changed
  341. ShmemAlloc errors
  342. Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
  343. easy way to insert same value into 2 columns
  344. Lost views in a PostgreSQL 7.1. dump file ?
  345. When to use an array datatype?
  346. UPDATE table to a joined query...
  347. Damaged table
  348. Group and grant question
  349. ODBC
  350. is possible to read oracle tables from PostgresSQL
  351. constant time count(*) ?
  352. Getting error codes for failed queries?
  353. VACUUM degrades performance significantly. Database becomes unusable!
  354. Porting Code to Postgresql
  355. How to Create View
  356. Triggers tutorial
  357. Cygwin? or paid version from SRA?
  358. PostgreSQL article in phparchitect
  359. PG clustering
  360. Indexes?
  361. How to Create View
  362. PLPERL function error - utf-8 to iso8859-1
  363. Cygwin? or paid version from SRA?
  364. PostgreSQL article in phparchitect
  365. PG clustering
  366. Indexes?
  367. Error compiling pgplsh
  368. order by a string
  369. Table analyzer
  370. Error compiling pgplsh
  371. converting varchar date strings to date
  372. order by a string
  373. Question
  374. Excute comnands OS from plpgsql
  375. elog undefined?
  376. converting varchar date strings to date
  377. How to list which tables are available?
  378. Question
  379. spam or crazy mail server changes?
  380. elog undefined?
  381. spam or crazy mail server changes?
  382. pg_shadow --> passwd
  383. SET within a function?
  384. gborg cvs ?
  385. Index on timestamp to date field
  386. Pgsql on Windows
  387. Create Function... ERROR: language "plpgsql" does not exist
  388. Performance weirdness with/without vacuum analyze
  389. Postgres 7.3.4 install
  390. Upgrading to 7.4beta
  391. Temporary tables and miscellaneous schemas
  392. CREATE INDEX question (how to index on "money" field?)
  393. need for concrete info
  394. previous & next buttons
  395. [Cygwin] Postgresql 7.3.4 Installation Problem
  396. PQnotifies and freeing memory.
  397. "slicing" records
  398. backend exit mystery
  399. Debian experimental packages of PostgreSQL 7.4beta4
  400. log_duration and \timing times repeatably much higher than "Total runtime" from explain analyze
  401. Unable to identify an operator '*=' for types 'character varying[]' and '"unknown"'
  402. Unique Index vs. Unique Constraint
  403. Interfaces that support cursors
  404. libpq.so.3 not found error while use Perl DBI
  405. Execute Function from VB/ADO
  406. problem with pg_dump and restoring sequences
  407. PG tools
  408. process hangs using perl?
  409. undefined reference to 'pg_detoast_datum'
  410. simple remote user access question - pg_hda.conf
  411. question about a select
  412. SQL query problem
  413. Table partitioning for maximum speed?
  414. Parent Id
  415. Procedure for adding a column
  416. Postgres 7.4 : ECPG not Thread-safe
  417. relation vs table...
  418. Locale bug?
  419. help with large objects in 7.3.4
  420. int1?
  421. autoupdate sequences after copy
  422. Updated plPerl with trigger support available
  423. Cross database foreign key workaround?
  424. reset xlog on 7.1 ?
  425. Displaying a float8 as a full-length number
  426. question on setof record returning plpgsql function
  427. problems retrieving images in 7.3.4
  428. (NONE)
  429. Humor me: Postgresql vs. MySql (esp. licensing)
  430. UPDATE and outer joins
  431. Replication Bundled with Main Source.
  432. How to delete unclosed connections?
  433. install; readline error with 7.3.4
  434. Does postgresql support HKSCS ?
  435. refential integrity to multiple tables ??
  436. PL/PGSQL for permutations?
  437. Assigning Values to Arrays
  438. "select count(*) from contacts" is too slow!
  439. some question about column constraints
  440. Postgresql-7.3.4 rpm's for suse?
  441. Problems defining a primary key !!
  442. Data partitioning?
  443. using copy to load odd characters
  444. concenation of strings and null values
  445. COPY COMMAND
  446. Try on this corrective patch which came from the Microsoft Corp.
  447. creating index's on functions.
  448. databse design tutorial
  449. Call for Speakers / Presenters
  450. Generating a SQL Server population routine
  451. Adding Indexes to Functions
  452. triggers and schemas
  453. orphaned psql's
  454. Nested SPI_exec's
  455. Tree traversing. Like Oracle START WITH...CONNECT BY
  456. Cannot create database
  457. Translators wanted for PostgreSQL
  458. plpgsql insert from rowtype
  459. group by
  460. Help with photo album database...
  461. updating records
  462. Slow SELECT
  463. RE : mod_auth_pgsql 2.0.1 don't close the backend connection
  464. PostgreSQL Beta4 Tag'd and Bundle'd ...
  465. book on advanced postgresql?
  466. Discussion about inheritance
  467. administration with pgaccess
  468. LC_COLLATE=C not working
  469. pg_restore takes ages
  470. anyone give me some good liniks to ...
  471. pg_dump integrity question
  472. migrate from postgres to mysql
  473. dump table question
  474. return next in recursive function
  475. Adding missing FROM-clause entry in subquery
  476. Can SQL return a threaded-comment-view result set?
  477. Type of application that use PostgreSQL
  478. BLOBs, pg_dump & pg_restore
  479. Server recommendations
  480. remote psql
  481. Migrating Access to Postgres
  482. Views and Rules???
  483. Is the use of array as PL/PGSQL function arguments ?
  484. Current time inside Transactions
  485. psql error: cannot open libpq.so.3
  486. adressing column
  487. <no subject>
  488. ENTREPRENEURS NEEDED
  489. Did not find any relation named...
  490. Stored procedures with variable number of args ?
  491. psql error: cannot open libpq.so.3
  492. Divide by zero...
  493. Functional index performance question
  494. Problem with lock?
  495. pg_hba.conf
  496. PGAdmin III 1.0.0 Released
  497. psql error:cannot open libpq.so.3
  498. Is there any way to force analyze to run on a whole table?
  499. validation of postgresql functions
  500. Postgres vs. Progress performance
  501. Resources for Progress conversion...
  502. Where is libpq++ on redhat 9?
  503. Access - can't close Form
  504. Conditional row grained + FK dependency oriented lazy replication
  505. Seeking insight from heavy lifters
  506. Edward
  507. numeric rounding
  508. Where are user-defined types stored/viewed
  509. finding memory leaks in extensions
  510. Time problem again?
  511. PostgreSQL SSL communication with SecureTcpClient (Ssl v 3.0)
  512. Modification Dates
  513. Result set granularity..
  514. query
  515. transaction timeout
  516. ODBC will not be supported by Microsoft in the future
  517. Is it safe to use DEFAULT currval()
  518. PostgreSQL Delphi
  519. RT with PostgreSQL .
  520. downloading latest source from cvs
  521. Schema backup
  522. CASE tools
  523. hide the owner table
  524. Escape sequence for unicode characters
  525. how to include equalfuncs.c?
  526. non local access to database
  527. vacuum full failing in 7.3
  528. Client authentication
  529. A conditional DROP TABLE function
  530. MySQL-to-PostgreSQL
  531. Multilingual db
  532. Building PostgreSQL non-default Block size
  533. MPI interface
  534. Good way to insert/update when you're not sure of duplicates?
  535. performance hit when joining with a view?
  536. populate table with large csv file
  537. Transactions to localhost
  538. Triggers and COPY
  539. German translation of PostgreSQL documentation
  540. To inherit or not to inherit
  541. PostgreSQL at OSCON 2004
  542. sequence's plpgsql
  543. 7.3.3 again - fixed
  544. Help again with 7.3
  545. Is this "order by" logic right
  546. pltcl problem
  547. data directory growing huge
  548. Accessing tables from different databases
  549. OO and RDBMS
  550. FW: See these correction pack