View Full Version : Pgsql General



  1. Re: Applications that leak connections
  2. How to delete duplicate rows?
  3. Re: How to delete duplicate rows?
  4. Re: How to delete duplicate rows?
  5. Re: Help with strange join
  6. Re: Is there a peer-to-peer server solution with PG?
  7. Re: Applications that leak connections
  8. Re: How to delete duplicate rows?
  9. Re: error-tolerant COPY FROM
  10. Re: pgpool 2.5b2 released
  11. Postgresql 8.0 beta 5 setup in windowsxp
  12. Is there a peer-to-peer server solution with PG?
  13. Re: Backing up and restoring a database with the SELinux pg_user problem.
  14. PostgreSQL CFV
  15. REPLICATION Solution for WINDOWS OS
  16. Re: [OT] PostgreSQL: bytea help needed.
  17. Re: Is there a peer-to-peer server solution with PG?
  18. Start problem on OSX
  19. Re: Lost rows/data corruption?
  20. Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
  21. Re: Eeek! Major problem after reload with tsearch2
  22. Re: Select from function for part of column results
  23. psql question on echo output
  24. SQL query question
  25. Re: Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
  26. Re: plpython.so
  27. Re: multidimensional arrays
  28. Re: SQL query question
  29. Re: Problem with the sequence
  30. Re: SQL query question
  31. Re: SQL query question
  32. Re: When is a blank not a null or ''
  33. Re: When is a blank not a null or ''
  34. Re: When is a blank not a null or ''
  35. Re: When is a blank not a null or ''
  36. Re: plpython.so
  37. Re: Invalid headers and xlog flush failures
  38. Re: basic pg lock question
  39. Re: When is a blank not a null or ''
  40. capturing/viewing sort_mem utilization on a per query basis
  41. dumping and restoring user information.
  42. codepage setting, \encoding
  43. Locking of auto generated sequence
  44. Re: query time
  45. PL/PgSQL, Inheritance, Locks, and Deadlocks
  46. unsubscribe
  47. Re: basic pg lock question
  48. Re: basic pg lock question
  49. Error Message
  50. modifying views
  51. delphi -> postgresql database connect ???
  52. Wierd memory problem with Apache / PHP. Related to pg_query ?
  53. Re: PL/PgSQL, Inheritance, Locks, and Deadlocks
  54. Re: PL/PgSQL, Inheritance, Locks, and Deadlocks
  55. Weird PostgreSQL crashes on FC2/FC3 64-bit
  56. Re: dumping and restoring user information.
  57. Re: Import SVG file
  58. XML-RPC problem with array
  59. Re: postgres session termination
  60. Re: postgres session termination
  61. Re: postgres session termination
  62. Re: Howto determin the number of elemnts of an array
  63. Re: 8.0.0 RC5-2 Processes/Interfaces Under Windows
  64. Betr: Re: codepage setting, \encoding
  65. Re: uniqueidentifier-0.2
  66. Dynamic SQL
  67. pg_dump in 7.2.4 with trigger functions
  68. Postgresql and Athlon64 ?
  69. Re: Postgresql and Athlon64 ?
  70. Re: Dynamic SQL
  71. Dereferencing a 2-dimensional array in plpgsql
  72. Re: postgres session termination
  73. Re: Postgresql and Athlon64 ?
  74. Error Message
  75. Problem: 32 Argument function parameter list
  76. Increasing the length of a varchar domain
  77. cmin increments by 2 except in 7.4?
  78. Re: PostgreSQL Security Release
  79. Re: Locking of auto generated sequence
  80. Re: Howto determin the number of elemnts of an array
  81. Re: postgres session termination
  82. Re: Dereferencing a 2-dimensional array in plpgsql
  83. Re: how to release a transaction lock on a table?
  84. unsubscribe
  85. Re: postgres session termination
  86. Re: Dynamic SQL
  87. Re: Dereferencing a 2-dimensional array in plpgsql
  88. Re: Dereferencing a 2-dimensional array in plpgsql
  89. table name restiction
  90. Re: how to release a transaction lock on a table?
  91. Re: postgres session termination
  92. Re: table name restiction
  93. conflict types mysql and PostgreSQL
  94. change table to view problem
  95. Re: how to release a transaction lock on a table?
  96. Re: pg_dump in 7.2.4 with trigger functions
  97. Re: "Invalid multibyte character for locale" still there
  98. Re: Postgresql and Athlon64 ?
  99. Re: pg_dump in 7.2.4 with trigger functions
  100. Re: "Invalid multibyte character for locale" still there
  101. Re: pg_dump in 7.2.4 with trigger functions
  102. Howto determin the number of elemnts of an array
  103. Problem with Autogenerated sequence
  104. Re: postgres session termination
  105. Freeradius and Postgresql
  106. postgresql 7.4.6 slowing down
  107. 8.0.0 RC5-2 Processes/Interfaces Under Windows
  108. FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
  109. ANNOUNCE: ShellSQL 0.7
  110. Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
  111. dumping the schema ?
  112. example for read committed/volitile functions
  113. Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
  114. Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
  115. Re: PL/pgSQL functions and RETURN NEXT
  116. Re: PL/pgSQL functions and RETURN NEXT
  117. pgpool 2.5b2 released
  118. Re: Splitting queries across servers
  119. Pinning buffers for long times like outer joins might do.
  120. Re: [pgsql-advocacy] MySQL worm attacks Windows servers
  121. Re: [pgsql-advocacy] MySQL worm attacks Windows servers
  122. inet-type sequence
  123. complete instruction in trigger?
  124. Re: question about porting least and greatest from oracle
  125. Re: inet-type sequence
  126. Re: inet-type sequence
  127. Re: dumping the schema ?
  128. Re: Splitting queries across servers
  129. Prompt User From a pgplsql Function
  130. Re: Splitting queries across servers
  131. Re: Splitting queries across servers
  132. Guess what database is MIA from LinuxWorld's Reader's Choice
  133. View definition truncated in information_schema
  134. Re: visualizing B-tree index coverage
  135. Re: Splitting queries across servers
  136. Re: Oracle and PostgreSQL
  137. how to read do the psq \i command
  138. Re: inet-type sequence
  139. Re: Prompt User From a pgplsql Function
  140. Re: Prompt User From a pgplsql Function
  141. Postgresql v8.0 debian packages.
  142. Bug in COPY from CSV?
  143. change encoding ?
  144. Re: change encoding ?
  145. upgrading to postgresql 8
  146. Re: View definition truncated in information_schema
  147. Re: [SQL] URL activation through trigger
  148. Re: Import SVG file
  149. Mail list / web issues
  150. convert mdb files to pg?
  151. Re: Splitting queries across servers
  152. Re: Mail list / web issues
  153. Re: [pgsql-advocacy] OLS BOF for linux & postgresql
  154. postgress gnuplot and Geometric
  155. Re: Oracle and PostgreSQL
  156. Re: [BUGS] My postmaster just crashed !
  157. Re: [BUGS] My postmaster just crashed !
  158. Re: how to read do the psq \i command
  159. Re: tsearch2 document and word limit
  160. xlog flush request 0/215D32E4 is not satisfied
  161. Pg database, need a solution to a problem
  162. Re: Moving from Sybase to Postgres - Stored Procedures
  163. rowset-returning function mismatch
  164. Re: Pg database, need a solution to a problem
  165. Moving within a cursor declared in plpgsql function
  166. Rule problem with OLD / NEW record set (repost)
  167. Re: rowset-returning function mismatch
  168. Re: upgrading to postgresql 8
  169. Allowing update of column only from trigger
  170. Moving from Sybase to Postgres - Stored Procedures
  171. Shared Memory/Shared Buffers
  172. How to get back the current count of a auto incrementing number.
  173. How to read sql commans from file resolved
  174. Re: convert mdb files to pg?
  175. Re: convert mdb files to pg?
  176. Import SVG file
  177. query variables
  178. Re: Import SVG file
  179. initdb failed
  180. Re: convert mdb files to pg?
  181. changing sort_mem on the fly?
  182. Re: convert mdb files to pg?
  183. Re: xlog flush request 0/215D32E4 is not satisfied
  184. Numeric type
  185. Re: pg_dump shell script with ~/.pgpass
  186. tsearch2 document and word limit
  187. Moving from Sybase to PostgreSQL - Stored Procedures
  188. Oracle and PostgreSQL
  189. Re: pg_dump shell script with ~/.pgpass
  190. An interesting pgpool benchmark result
  191. log_min_duration_statement
  192. Problem with the copy command need help
  193. How to find out about the functions supported in Postgres 8
  194. Best practices - permission handling
  195. GiST index not used for ORDER BY?
  196. Re: last tuple affected
  197. Return value of 'serial' column on insert
  198. Scanning the PGSQL DB
  199. Foreign Key relationship between two databases
  200. Re: Numeric type
  201. last tuple affected
  202. Re: EMBEDDED PostgreSQL
  203. more information for SRF function
  204. backslashes in queries containing LIKE
  205. cleanup of pg_temp schemas
  206. Re: cleanup of pg_temp schemas
  207. Re: Partitioning Postgresql
  208. Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)
  209. Partitioning Postgresql
  210. Problem with NOT IN and Sub-Select
  211. Partitioning Postgresql
  212. Re: Problem with NOT IN and Sub-Select
  213. Re: Apparently I don't understand full outer joins....
  214. Lower case
  215. how come I get this error message when I try to connect to Postgresql
  216. Export a column in a view without "announcing" it?
  217. Re: backslashes in queries containing LIKE
  218. Splitting queries across servers
  219. Re: log_min_duration_statement
  220. Re: cleanup of pg_temp schemas
  221. Size of data stored in bytea record?
  222. Re: EMBEDDED PostgreSQL
  223. Re: Size of data stored in bytea record?
  224. visualizing B-tree index coverage
  225. Re: visualizing B-tree index coverage
  226. Re: visualizing B-tree index coverage
  227. Apparently I don't understand full outer joins....
  228. Problem with Postgres V 8 and DBI maybe
  229. Re: EMBEDDED PostgreSQL
  230. Re: Lower case
  231. Re: visualizing B-tree index coverage
  232. text field constraint advice
  233. Re: Lower case
  234. Re: EMBEDDED PostgreSQL
  235. Re: EMBEDDED PostgreSQL
  236. Re: EMBEDDED PostgreSQL
  237. Re: text field constraint advice
  238. working with multidimensional arrays in plpgsql
  239. Good PostgreSQL Based Shopping Cart Software ... ?
  240. Re: visualizing B-tree index coverage
  241. Re: Problem with Postgres V 8 and DBI maybe
  242. Free Playstation 3 (PS3) here !
  243. Restore de Base de datos
  244. Delete with a multi-column join?
  245. Re: Apparently I don't understand full outer joins....
  246. Re: Apparently I don't understand full outer joins....
  247. Re: Apparently I don't understand full outer joins....
  248. ODBC Driver Issue (possibly OT - wrong list?)
  249. Postgresql, SQL server and Oracle. Please, help
  250. PostgreSQL 8.0 for RH AS