View Full Version : Pgsql General



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