PDA

View Full Version : Pgsql General

  1. Re: Problem running native windows Postgres 8 pg_dump etc on
  2. Re: Problem running native windows Postgres 8 pg_dump etc on cygwin from bash
  3. Problem running native windows Postgres 8 pg_dump etc on cygwin frombash
  4. pl/pgsql trigger: syntax error at or near "ELSEIF"
  5. Re: Insufficient system resources for PostgreSQL 7.4.x?
  6. Re: pl/pgsql trigger: syntax error at or near "ELSEIF"
  7. Insufficient system resources for PostgreSQL 7.4.x?
  8. PQexecParams and CURSOR
  9. Invalid input for numeric problem
  10. OID Usage
  11. 7.4.6 FC2 MUCH slower from 2.6.9-1.11 to 2.6.10-1.8
  12. Re: Cursor bug?
  13. Version Control Software for Database Objects
  14. Re: Cursor bug?
  15. Functions that return RECORD type
  16. best place to enfore rules
  17. Functions returning RECORD
  18. pgpool
  19. =?iso-8859-1?Q?R=E9f=2E_=3A_Re=3A_R=E9f=2E_=3A_Re=3A_R=E9f=2E _=3A_[?==?us-ascii?Q?GENERAL?= =?us-ascii?Q?]_?= =?us-ascii?Q?Debugging?= SPI Cfunctions
  20. allowing connections from additional hosts without a restart?
  21. =?iso-8859-1?Q?R=E9f=2E_=3A_Re=3A_R=E9f=2E_=3A__Debugging_SPI _C?=functions
  22. Trace triggers
  23. Adding UNIQUE constraint on NULL column
  24. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  25. Interval Question
  26. Database "template1" does not exist in the system catalog
  27. index on user defined type
  28. Re: Postgresql 8.0 and Cancel/Kill backend functions
  29. Modifying search_path in a stored procedure
  30. Postgresql didn't start after power failure
  31. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  32. Re: Modifying search_path in a stored procedure
  33. Re: Simulating WAL on separate disks
  34. Postgresql 8.0 and Cancel/Kill backend functions
  35. plpgsql/rule question
  36. vacuum vs open transactions
  37. OID of current function
  38. How to return a resultset/table from a sql function?
  39. how to determine initdb locale (after the event)?
  40. pgsqlODBC problems
  41. views in 8.0
  42. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  43. Re: index on user defined type
  44. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  45. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  46. Re: Interval Question
  47. int4 -> unix timestamp -> sql timestamp; abstime?
  48. Re: int4 -> unix timestamp -> sql timestamp; abstime?
  49. Running a void function in psql
  50. Bug in pg_dump in 7.4.6?
  51. Optimistic concurrency control
  52. Re: [HACKERS] Much Ado About COUNT(*)
  53. problem with the select query
  54. =?iso-8859-1?Q?R=E9f=2E_=3A__Debugging_SPI_C_functions?=
  55. Re: Optimistic concurrency control
  56. Re: Optimistic concurrency control
  57. Debugging SPI C functions
  58. Re: Bug in pg_dump in 7.4.6?
  59. Re: plpgsql/rule question
  60. Database "template1" does not exist in the system catalog.
  61. Re: plpgsql/rule question
  62. Re: Running a void function in psql
  63. Re: Interval Question
  64. Re: Private or publice function
  65. Re: int4 -> unix timestamp -> sql timestamp; abstime?
  66. Re: Postgresql didn't start after power failure
  67. Re: Bug in pg_dump in 7.4.6?
  68. Re: vacuum vs open transactions
  69. Re: vacuum vs open transactions
  70. Re: plpgsql/rule question
  71. Re: Database "template1" does not exist in the system catalog.
  72. Re: How to return a resultset/table from a sql function?
  73. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  74. Re: OID of current function
  75. Re: Postgresql didn't start after power failure
  76. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  77. Re: Interval Question
  78. Re: Modifying search_path in a stored procedure
  79. Question about pg_stat_activity
  80. Re: index on user defined type
  81. pgEdit 1.0b6
  82. Re: Postgresql Text field / Visual FoxPro Memo and ODBC
  83. Re: Question about pg_stat_activity
  84. Re: vacuum vs open transactions
  85. Working on a new Postgres Admin tool and was wondering...
  86. problems with 8.0 Rc4
  87. Re: Interval Question
  88. Re: Interval Question
  89. PostGreSQL on Access Report
  90. datestyle formatting
  91. handing created and updated fields
  92. Re: handing created and updated fields
  93. large dbII to postgresql migration
  94. Link to development version of docs on website?
  95. Re: datestyle formatting
  96. Re: datestyle formatting
  97. Private or publice function
  98. Re: Database "template1" does not exist in the system catalog.
  99. Re: Link to development version of docs on website?
  100. Re: Link to development version of docs on website?
  101. Simulating WAL on separate disks
  102. warning: pg_query(): Query failed
  103. to_char(0,'9999.99') -> ".00"
  104. Limiting USAGE to only certain objects within a schema
  105. SELECT from multiple tables (not join though)
  106. Re: handing created and updated fields
  107. Function for retreiving datatype
  108. PostgreSQL 8 on windows very slow
  109. ORDER BY in UNION query
  110. Re: handing created and updated fields
  111. Postgres 8 release
  112. could not open relation No such file or directory after alter table
  113. Re: Regexp matching: bug or operator error?
  114. Re: PYTHON, ODBC
  115. Re: configuration problems of postgresql under windows xp
  116. PITR questions
  117. =?KOI8-R?Q?Get execution plan of dynamic query?=
  118. configuration problems of postgresql under windows xp
  119. general list
  120. Is it possible to measure IO costs of a query in postgreSQL?
  121. PYTHON, ODBC
  122. how to optimize my c-extension functions
  123. large installation help.
  124. [OT] Dell Perc 3/di raid monitoring for PG db server
  125. returning a setof tuples like a subquery was(RE: ERROR:cache lookup failed for type 0 )
  126. bgwriter
  127. Re: need help Connect failure in an applet
  128. Re: Problem creating trigger-function with arguments (8.0rc4)
  129. Re: Problem creating trigger-function with arguments (8.0rc4)
  130. Re: ERROR: cache lookup failed for type 0
  131. MS-SQL to PostgreSQL
  132. how to migrate a complete win/interbase6 DB
  133. J2SE 1.5 Cache Rowset(JSR 114 )
  134. Re: Books for experienced DB developer
  135. ERROR: cache lookup failed for type 0
  136. need help Connect failure in an applet
  137. Re: need help Connect failure in an applet
  138. Transaction size
  139. unsubscribe
  140. PL/Perl
  141. does "select count(*) from mytable" always do a seq scan?
  142. Re: Books for experienced DB developer
  143. Books for experienced DB developer
  144. Re: Books for experienced DB developer
  145. Re: Books for experienced DB developer
  146. Re: Books for experienced DB developer
  147. Books for experienced developers
  148. Re: Query, view join question.
  149. Re: Global/persistent variables
  150. Query, view join question.
  151. Editor: Syntax highlighting and stored procedures surrounded by '
  152. Question about varchar and text
  153. unsubscribe
  154. Re: Question about varchar and text
  155. ltree valid characters
  156. Serial Foreign Key
  157. question about plpythonu
  158. pg_dump dependencies
  159. DBMS_File Equivalent?
  160. Re: Query, view join question.
  161. Re: Editor: Syntax highlighting and stored procedures surrounded
  162. functions in postgresql
  163. Global/persistent variables
  164. Re: Query, view join question.
  165. Re: Question about varchar and text
  166. Re: pg_dump dependencies
  167. postgresql-contrib risks?
  168. function corresponging to over in db2
  169. Re: SELECT WHERE NOT, is not working
  170. warning: pg_query(): Query failed
  171. problem finding the 8.0.3RC download
  172. multi column index and order by
  173. Happiness is a cross database link...
  174. Re: Happiness is a cross database link...
  175. Index on a view??
  176. Re: Index on a view??
  177. Re: Index on a view??
  178. SELECT WHERE NOT, is not working
  179. Trigger Question
  180. Re: Trigger Question
  181. Re: SELECT WHERE NOT, is not working
  182. Re: problem finding the 8.0.3RC download
  183. Re: multi column index and order by
  184. Re: warning: pg_query(): Query failed
  185. Re: warning: pg_query(): Query failed
  186. Passing a ROWTYPE to a function
  187. calculating costs.
  188. vacuum is failing
  189. Re: hundreds of millions row dBs
  190. PostgreSQL users on webhosting
  191. PostgreSql replication with heterogeneous databases!
  192. changing column from int4 to int8, what happens with indexes?
  193. varchar vs text
  194. Re: hundreds of millions row dBs
  195. hundreds of millions row dBs
  196. Mailwatch postgresql support ?
  197. Re: Can't change password?
  198. C function taking a relation and returning a similar relation.
  199. Re: Generating unique values for TEXT columns
  200. Generating unique values for TEXT columns
  201. PostgreSQL 8.0.0 RC3 RPMs for SUSE LINUX
  202. help with a stored procedure
  203. Can't find relation oid
  204. Merging Data from Multiple DB
  205. function in postgres
  206. Joined delete
  207. Index, Tablespace and performance
  208. Re: Select number of children of a parent query
  209. OS X shared memory problems 8.0rc3
  210. Re:
  211. Shared Sequences?
  212. PostgreSQL 8.0.0 Release Candidate 3
  213. citext datatype
  214. Question on a select
  215. Function Parameters
  216. many similar indexbased selects are extremely slow
  217. Re: ECPG Segfaulting on EXEC SQL connect
  218. Re: pgodbc error
  219. 'distinct on' and 'order by' conflicts of interest
  220. Re: [PATCHES] reqd patch
  221. Can't change password?
  222. Can you use an array of variables in a function?
  223. Re: [PATCHES] reqd patch
  224. Re: Large Objects
  225. Re: Tracking back foreign keys?
  226. Re: looking for connection leaks
  227. pgodbc error
  228. using pg_config to get LDFLAGS?
  229. vaccum db fail
  230. ECPG Segfaulting on EXEC SQL connect
  231. postgresql 8.0 Rc1
  232. Recursive update
  233. postgresql 8.0 rc1
  234. Postgresql website issues.
  235. syntax for inserting unicode character literal
  236. possible to DELETE CASCADE?
  237. Update rule
  238. Roadmap for Database Kernel XA Support
  239. Fwd: Advice on moving rows to history
  240. WARNING: group with ID NNN does not exist
  241. Advice on moving rows to history
  242. debug_print_plan (pg7.4) doesn't seem to do anything
  243. pg_dump and pgpool
  244. Re: BCD format
  245. BCD format
  246. pgsql question
  247. Re: 8.0 Beta3 worked, RC1 didn't!
  248. FW: 8.0 Beta3 worked, RC1 didn't!
  249. Re: running a query file of 42MB
  250. Re: Get current trasanction id