View Full Version : Pgsql General



  1. Is anyone using ha-jdbc with the <distributable> tag
  2. how to debugg
  3. Re: What is your favorite front end for user interaction to postgresql databases?
  4. What is your favorite front end for user interaction to postgresql databases?
  5. pg_dump and grants to PUBLIC
  6. exporting quoted CSV data from a query
  7. pg_restore duplicate key violations
  8. Re: Using the REPLACE command to replace all vowels
  9. Re: database size grows (even after vacuum (full and analyze))....
  10. DBD::Pg 1.49 released
  11. how to debug
  12. recuperar el nro del registro actualizado utilizando Ado
  13. Database limits
  14. catalog is missing 16 attribute(s) for relid 8202590
  15. dumb but existential question
  16. How to add plPHP to Postgresql
  17. Winning
  18. recuperar el nro del registro actualizado utilizando Ado
  19. can't reindex a couple of tables
  20. Where I find examples of pqtrace ???
  21. Can't Figure Out Where Rows Are Going
  22. help debugging hung process
  23. i need perl help for gborg project about mysql conversion
  24. Composite types and NULL within PL/pgSQL
  25. How to tune function plpgsql
  26. Re: EnterpriseDB
  27. Is an updateable/insertable recordset via ADO possible using MS-Access?
  28. EnterpriseDB
  29. Re: Rules on Select
  30. intarray internals
  31. Rules on Select
  32. Google Summer of Code: Full Disjunctions
  33. can't reindex a couple of tables
  34. Re: Field names and NEW
  35. ERROR: more than one row returned by a subquery used as an expression
  36. Unify distant Postgres databases
  37. Field names and NEW
  38. Syntax problem for a newbie
  39. simple md5 authentication problems
  40. Function query plan
  41. Googles sommer of Code 2005 - Postgres Project Proposal - where to discuss? who is responsible? who can mentor?
  42. Adding ON UPDATE CASCADE to an existing foreign key constraint
  43. Re: Segfaults with 8.1.3 on amd64
  44. ilike and umlaut
  45. Intel Duo Issues
  46. linker
  47. Segfaults with 8.1.3 on amd64
  48. ISSTRICT behavior
  49. pg_dumpall error
  50. Catch individual exceptions
  51. Re: logfiles filling up
  52. Connection error, help..please
  53. Re: How does an application recognize the death of the postmaster
  54. How does an application recognize the death of the postmaster
  55. map real estate prices using HomePriceMaps.com
  56. Re: logfiles filling up
  57. The planner chooses seqscan+sort when there is an index on thesort column
  58. Re: psql is slow and it does not take much resources
  59. Re: psql is slow and it does not take much resources
  60. Re: psql is slow and it does not take much resources
  61. psql is slow and it does not take much resources
  62. Re: logfiles filling up
  63. Re: Using the REPLACE command to replace all vowels
  64. logfiles filling up
  65. Replicating PostgreSQL DB to lightweight system
  66. Locking confusion
  67. Recovering a row result
  68. Re: file I/O in plpgsql
  69. shp2pgsql
  70. age(datfrozenxid) negative for template0. Is this normal?
  71. Re: convert LO to BYTEA
  72. FATAL: database "dspace" does not exist"
  73. Calling V1 function from within the server
  74. 8.1.4 anytime soon?
  75. libpq for palm?
  76. convert LO to BYTEA
  77. number of page slots needed exceeds max_fsm_pages
  78. Unnecessary function calls
  79. Using a pointer as statetype for an aggregate
  80. Return value (instead of reference) for user defined type
  81. How to join to delete
  82. insert into a view?
  83. Re: How would I write this query...
  84. Using the REPLACE command to replace all vowels
  85. Leading substrings - alternatives with 8.1.3?
  86. Re: How would I write this query...
  87. charting performance measures with number or records in table
  88. Authentication & connection problems
  89. OT: job offer
  90. Re: Is PostgreSQL an easy choice for a large CMS?
  91. PG_RETURN_?
  92. Nested Query OK in psql but not in PHP
  93. pg_dump warings
  94. How would I write this query...
  95. Operator Class for Hash
  96. Is PostgreSQL an easy choice for a large CMS?
  97. Select / sub select? query... help...
  98. how can i view deleted records?
  99. file I/O in plpgsql
  100. Repost: Problem with pg_ctl register -w
  101. Postmaster process on port 10000
  102. configure: error
  103. Order of triggers and sequences...
  104. dump Functions
  105. Use of ISpell dictionaries with tsearch2 - what is the point?
  106. Re: Autovacuum Logging
  107. Postmaster process on port 10000
  108. Init script for 8.1 compiled on Debian Stable
  109. Re: Alternative for vacuuming queue-like tables
  110. Alternative for vacuuming queue-like tables
  111. Is it possible to summarize uniqe values from an indexed column?
  112. A few things on intervals
  113. How to define + operator for strings
  114. Re: Installing PostgreSQL on Win 2003 R2 64-bit
  115. I18N
  116. For vim users: Syntax highlighting for PostgreSQL
  117. Checking for Foreign Keys constraining a record?
  118. Help with unpredictable use of indexes on large tables...
  119. [Announce] mod_sqil: an RDMS => XML mapper apache module
  120. trying to write a many-to-many type function.
  121. Unexpected behavior
  122. CALCULAR EDAD!
  123. query that needs two nested queries, is this the best way?
  124. Vacuum suggesting doubling of max_fsm_pages
  125. PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!!PLEASE HELP
  126. selecting column comment
  127. FW: Postgres 8.1 sequences and 'CALL'-syntax
  128. CREATE TYPE
  129. Postgres on WinXP - app on Cygwin
  130. triger and transaction
  131. Postgres 8.1 sequences and 'CALL'-syntax
  132. Re: Mailing list setup issue
  133. Mailing list setup issue
  134. Re: [HACKERS] pg_dump
  135. Disk Failure Scenarios
  136. Autovacuum Logging
  137. PostgreSQL 8.1 + PHP5.1.x/4.4.2 + Apache 2.0.55/1.3.34 PROBLEM!!PLEASE HELP
  138. Installing PostgreSQL on Win 2003 R2 64-bit
  139. problem with unique text column
  140. Problem with copy
  141. Re: Clustered table order is not preserved on insert
  142. RES: Moving a data base between differnt OS
  143. Moving a data base between differnt OS
  144. Clustered table order is not preserved on insert
  145. pg_dump -t <> pg_restore -t
  146. Re: PL/Ruby, INOUT parameters / SETOF record
  147. Re: Question about postgresql.conf memory settings
  148. evaluating equation stored in a string
  149. Question about postgresql.conf memory settings
  150. Ordering of records in group by not possible
  151. Linux Journal article - Open source baseball stats web site willuse PostgreSQL
  152. Cascade constraint renames?
  153. Problem with complex outer join expression
  154. (NONE)
  155. Disk failure scenarios
  156. "ERROR: out of memory" during pg_restore
  157. SQL Rule
  158. Please comment on the following OpenFTS/tsearch2 issues!
  159. Having problems with a 25 million row table on 8.1.3
  160. how can I check the error status??
  161. Anyone install 8.1 on Debian Stable?
  162. Commit rules or Commit trigger
  163. postgreslog-semctl(7438339, 4, SETVAL, 0) failed:
  164. Starting Postgresql as windows service
  165. pg_dumpall: does not exist database
  166. invalid memory alloc request size 1684370054
  167. remove another version of postgreSQL
  168. Re: How to have a blind-superuser
  169. Re: "save history" problem
  170. Install issue on Kubuntu
  171. DatawareHousing
  172. Upgrade of Windows MSI installations (version 8.0)
  173. "save history" problem
  174. Re: HUGE Stack space is gettiing consumed
  175. Partitioning rule not behaving as expected
  176. isnumeric - checking if text variable is convertable to numeric
  177. How to have a blind-superuser
  178. How to close dead connections immediately
  179. How to avoid empty temp schemas
  180. Database Selection
  181. to know
  182. Transactions, PostgreSQL and MS Access front end.
  183. Concurrency problem building indexes
  184. Postgreql 8.0.3 temporary Table Strange behaviour
  185. Problems logging in
  186. Performance
  187. out of memory for query result
  188. Automatically assuming a specific role after connecting to pg
  189. Re: Debian package for freeradius_postgresql module
  190. Re: Debian package for freeradius_postgresql module
  191. Re: Debian package for freeradius_postgresql module
  192. Re: HUGE Stack space is gettiing consumed
  193. Daylight Savings Time
  194. IDT timezone
  195. Odd transaction timestamp sequence issue
  196. Triggers and Transactions
  197. A few questions about ltree
  198. psql: FATAL: missing or erroneous pg_hba.conf file
  199. temp tables problem
  200. Setup for large database
  201. setting the environment locale - linux, windows
  202. full text search: the concept of a "word"
  203. GiST index slower than seqscan
  204. sudo-like behavior
  205. odbc problem
  206. How to replace rows in table so that foreign key rows are not deleted
  207. Notification EXTRA data
  208. disk full scenario
  209. Re: postmaster services problem
  210. FW: code to cancel a running query, worker thread
  211. problem while adding a column
  212. recovery problem
  213. consulta SELECT FOR UPDATE
  214. postmaster services problem
  215. tomcat postgresql database connectivity error
  216. primary keys
  217. locating a primary key
  218. deleting table content through command prompt
  219. Calling the same function more than once with the same arguments
  220. plperl on AIX
  221. Error while adding a column
  222. Translating sql error codes
  223. help plpgsql, cursors, fetch into
  224. some error messages in postgeslog
  225. grant privileges across schemas
  226. strange query filter problems
  227. How to implement a "subordinate database"?
  228. code to cancel a running query, worked thread
  229. recovery problem
  230. page is uninitialized?
  231. tomcat postgresql connectivity error
  232. Re: catch SQLException, error code for Foeign key violation,
  233. Categories and Sub Categories (Nested)
  234. Bulk inserts within a Perl script?
  235. Partial indexes
  236. PostgreSQL and the OCFS2 filesystem
  237. Permission problem opening database
  238. Re: Thoughts on a Isolation/Security problem
  239. Weird error updating table
  240. Using pg_dump and pg_restore
  241. Give me some suggestion
  242. recovery with pg_xlog
  243. i have a core file on running gdb the op
  244. Re: Curious UDP packets
  245. select with date_part and month failure....
  246. Query to check existence of stored procedure?
  247. Postgresql and Creator2 commitChanges()
  248. Vacuuming of indexes on tables.
  249. Re: the integer type
  250. tsearch partial word