View Full Version : Pgsql General



  1. replication question
  2. Re: PostgreSQL vs. MySQL vs. Oracle, 2005 report card
  3. regular expression
  4. Index search order hints for R-Tree indexes
  5. /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG
  6. Re: possible bug with compound index.
  7. Re: [pgsql-www] Website Documentation
  8. Re: [pgsql-www] Website Documentation
  9. comparing dates with timestamps ?
  10. Re: comparing dates with timestamps ?
  11. Re: [pgsql-www] Website Documentation
  12. Re: regular expressions in query
  13. find next in an index
  14. Re: find next in an index
  15. Re: find next in an index
  16. problem with thai language
  17. Website Documentation
  18. Re: Website Documentation
  19. Re: Website Documentation
  20. Re: regular expressions in query
  21. Need 2,500 - 10,000 People
  22. ERROR: control reached end of function without RETURN
  23. Hello...
  24. How to fake an array of a user-defined type
  25. Re: Apparent anomaly with views and unions
  26. Re: Hello...
  27. SQL query
  28. Re: pg_affected Change Request
  29. Re: Hello...
  30. vacuum confusion
  31. Error from database
  32. Python Driver
  33. Re: SQL query
  34. Profiling ERROR Conditions
  35. regular expressions in query
  36. Python Interface
  37. parameters handling in postgresql functions
  38. Re: ERROR: control reached end of function without RETURN
  39. no self-joins in views?
  40. Postgresql and Macintosh
  41. Re: regular expressions in query
  42. Re: Python Driver
  43. Fwd: Unending recursive gmake during install?
  44. Re: Python Driver
  45. Re: Python Interface
  46. file descriptors
  47. pg_dump dumping data in order? (used to in 7.4 but not now in 8?)
  48. size in bytes of a table?
  49. Re: no self-joins in views?
  50. Re: file descriptors
  51. test datatype for ANY
  52. a few doubts regarding postgres
  53. Re: a few doubts regarding postgres
  54. Re: parameters handling in postgresql functions
  55. Re: file descriptors
  56. Re: databases/p5-postgresql-plperl links to wrong
  57. Re: SQL query
  58. Re: pg_dump dumping data in order? (used to in 7.4 but not now in 8?)
  59. Re: Python Driver
  60. Catching delete
  61. Re: Python Driver
  62. Apparent anomaly with views and unions
  63. Re: SQL query
  64. Re: SQL query
  65. how to capture query?
  66. Re: vacuum confusion
  67. Re: test datatype for ANY
  68. Question regarding threaded mode
  69. Re: test datatype for ANY
  70. Re: file descriptors
  71. Re: Python Driver
  72. Re: vacuum confusion
  73. views get 'lost'
  74. views don't get 'lost' :-)
  75. Re: a few doubts regarding postgres
  76. Re: Fwd: Unending recursive gmake during install?
  77. Unsubscribe
  78. WARNING: could not remove database directory
  79. Re: a few doubts regarding postgres
  80. PostgreSQL Features
  81. Re: vacuum confusion
  82. Re: no self-joins in views?
  83. Re: no self-joins in views?
  84. Re: Python Interface
  85. postgres server failure during some database opearion
  86. Any functions to convert bit(5) to text?
  87. Re: [SQL] Updating selected record
  88. how to delete from a view
  89. Re: Postgresql and Macintosh
  90. Database permissions
  91. Re: Postgresql and Macintosh
  92. Understanding EXPLAIN ANALYZE output
  93. Re: parameters handling in postgresql functions
  94. Re: Functions with more than 32 parameters
  95. Re: Understanding EXPLAIN ANALYZE output
  96. Re: Understanding EXPLAIN ANALYZE output
  97. FOR vs Cursors
  98. Re: Understanding EXPLAIN ANALYZE output
  99. EXTPROC External Procedure
  100. More concurent transaction over single connection ?
  101. Re: Postgresql and Macintosh
  102. Re: Postgresql and Macintosh
  103. Re: Postgresql and Macintosh
  104. Hoow do you drop a column in a table
  105. Backup restore does not work
  106. Re: Postgresql and Macintosh
  107. Re: More concurent transaction over single connection ?
  108. Re: More concurent transaction over single connection
  109. Re: Hoow do you drop a column in a table
  110. Re: Hoow do you drop a column in a table
  111. Re: Cannot connect to Database
  112. Re:
  113. Re: Cannot connect to Database
  114. Cannot connect to Database
  115. hi
  116. Re:
  117. Re: Cannot connect to Database
  118. What talk would get you to go to OSCon?
  119. Re: Cannot connect to Database
  120. Netstat - Lots of PG Connections
  121. Re:
  122. Removing duplicates
  123. Re: Cannot connect to Database
  124. Re: Cannot connect to Database
  125. Re: [COMMITTERS] How I can add new function writing on C under Win32
  126. Re: Postgresql and Macintosh
  127. Re: checking SQL statement/subexpression validity
  128. Re: Database permissions
  129. create temp table and on commit in 7.3.3
  130. Re: Backup restore does not work
  131. Re: Database permissions
  132. checking SQL statement/subexpression validity
  133. Re: Cannot connect to Database
  134. Re: Netstat - Lots of PG Connections
  135. Re: Netstat - Lots of PG Connections
  136. PL/pgSQL bug: FOUND variable is not updated correct with EXECUTE
  137. Re: What talk would get you to go to OSCon?
  138. indexing just a part of a string
  139. Re: Creating an index-type for LIKE '%value%'
  140. Re: Netstat - Lots of PG Connections
  141. Re: Cannot connect to Database
  142. Re: Creating an index-type for LIKE '%value%'
  143. Re: Safely Killing Backends (Was: Applications that leak connections)
  144. Re: indexing just a part of a string
  145. Re: Update command too slow
  146. Re:
  147. Performance tuning using copy
  148. Re: Confused by to_char
  149. Re: Confused by to_char
  150. Re:
  151. create aggregates to concatenate
  152. Re: Problem performing a restore of a data schema in Wi
  153. External Projects in the PostgreSQL release
  154. Re: PHP/PDO Database Abstraction Layer
  155. [SECURITY] New sets of PostgreSQL RPMS are available for download
  156. does the planner "learn"?
  157. Re: Creating an index-type for LIKE '%value%'
  158. Sorting when "*" is the initial character
  159. a SELECT FOR UPDATE question
  160. Re: Use of indexes with table inheritance
  161. Re: does the planner "learn"?
  162. Permissions on implicit SERIAL datatype seqeuences
  163. PG 8.0.1 Does not use Index with IS NOT NULL
  164. tsearch2 Trigger
  165. Out of memory error
  166. Re: Problem performing a restore of a data schema in Wi
  167. PostgreSQL, exception and PHP
  168. Problem performing a restore of a data schema in Windows
  169. Re: Problem with the sequence
  170. Can't build libpq test example
  171. Re: Referencing uninitialized variables in plpgsql
  172. Binding of "AS" vis "JOIN"
  173. Help with access check
  174. Referencing uninitialized variables in plpgsql
  175. Re: Referencing uninitialized variables in plpgsql
  176. Questions about functionality
  177. Re: Best Linux Distribution
  178. Problem with the sequence
  179. Error in trigger after upgrading to 8.0.1?
  180. Re: plpgsql function errors
  181. Re: Error in trigger after upgrading to 8.0.1?
  182. Help with sorting (ie. ORDER BY expression)
  183. security
  184. Problems with filter on timestamp
  185. Re: plpgsql function errors
  186. Backing up and restoring a database with the SELinux pg_user problem.
  187. Updating a table on local machine from remote linux server
  188. Re: plpgsql function errors
  189. Re: Postgresql 8.0 beta 5 setup in windowsxp
  190. Re: PostgreSQL Security Release
  191. Re: PostgreSQL Security Release
  192. Re: Update command too slow
  193. Re: Safely Killing Backends (Was: Applications that leak connections)
  194. Re: Update command too slow
  195. Eeek! Major problem after reload with tsearch2
  196. Re: plpython.so
  197. Re: how to release a transaction lock on a table?
  198. Re: Problem with the sequence
  199. PostgreSQL on cluster
  200. Indexed leading substring searches - worked, now doesn't
  201. Hiding databases
  202. Re: pgpool 2.5b2 released
  203. Re: Select from function for part of column results
  204. basic pg lock question
  205. Re: Questions about functionality
  206. Re: Update command too slow
  207. Re: Postgresql 8.0 beta 5 setup in windowsxp
  208. Re: Indexed leading substring searches - worked, now doesn't
  209. Re: plpython.so
  210. When is a blank not a null or ''
  211. Re: Eeek! Major problem after reload with tsearch2
  212. is this index bloat?
  213. Applications that leak connections
  214. Re: When is a blank not a null or ''
  215. Re: Safely Killing Backends (Was: Applications that leak connections)
  216. Re: plpgsql function errors
  217. Re: Safely Killing Backends (Was: Applications that leak connections)
  218. Can pg_restore also disable table CHECK contraint?
  219. Re: Safely Killing Backends (Was: Applications that leak connections)
  220. Re: Safely Killing Backends (Was: Applications that leak connections)
  221. Re: NewsServer down ?
  222. simple case syntax oddity in 8.0.0
  223. Re: PostgreSQL Security Release
  224. Invalid headers and xlog flush failures
  225. errors while restoring data.
  226. multidimensional arrays
  227. Re: Eeek! Major problem after reload with tsearch2
  228. Re: Problems with filter on timestamp
  229. Lost rows/data corruption?
  230. Upgrade from 7.4 -> 8.0.1 - problem with dump/restore
  231. Re: Hiding databases
  232. Re: errors while restoring data.
  233. Re: Binding of "AS" vis "JOIN"
  234. Fwd: Re: Updating a table on local machine from remote linux server
  235. Re: [ADMIN] vacuum ran out of space and now i cant get back into db
  236. Lost rows / corrupt data?
  237. ADO adCmdStoredProc PlPgSql-SP Parameters
  238. Re: plpgsql function errors
  239. Re: Questions about functionality
  240. plpgsql function errors
  241. Duration between two timestamps
  242. Re: Problem resolved (tsearch2 inhibiting migration)
  243. Re: Introducing the future Debian
  244. C++ Builder prob.
  245. Re: Help with strange join
  246. Postgres using up all my memory
  247. Re: Postgresql 8.0 beta 5 setup in windowsxp
  248. Problem resolved (tsearch2 inhibiting migration)
  249. mysql load_file() function
  250. error-tolerant COPY FROM