PDA

View Full Version : Pgsql General

  1. Re: handing created and updated fields
  2. Function for retreiving datatype
  3. PostgreSQL 8 on windows very slow
  4. ORDER BY in UNION query
  5. Re: handing created and updated fields
  6. Postgres 8 release
  7. could not open relation No such file or directory after alter table
  8. Re: Regexp matching: bug or operator error?
  9. Re: PYTHON, ODBC
  10. Re: configuration problems of postgresql under windows xp
  11. PITR questions
  12. =?KOI8-R?Q?Get execution plan of dynamic query?=
  13. configuration problems of postgresql under windows xp
  14. general list
  15. Is it possible to measure IO costs of a query in postgreSQL?
  16. PYTHON, ODBC
  17. how to optimize my c-extension functions
  18. large installation help.
  19. [OT] Dell Perc 3/di raid monitoring for PG db server
  20. returning a setof tuples like a subquery was(RE: ERROR:cache lookup failed for type 0 )
  21. bgwriter
  22. Re: need help Connect failure in an applet
  23. Re: Problem creating trigger-function with arguments (8.0rc4)
  24. Re: Problem creating trigger-function with arguments (8.0rc4)
  25. Re: ERROR: cache lookup failed for type 0
  26. MS-SQL to PostgreSQL
  27. how to migrate a complete win/interbase6 DB
  28. J2SE 1.5 Cache Rowset(JSR 114 )
  29. Re: Books for experienced DB developer
  30. ERROR: cache lookup failed for type 0
  31. need help Connect failure in an applet
  32. Re: need help Connect failure in an applet
  33. Transaction size
  34. unsubscribe
  35. PL/Perl
  36. does "select count(*) from mytable" always do a seq scan?
  37. Re: Books for experienced DB developer
  38. Books for experienced DB developer
  39. Re: Books for experienced DB developer
  40. Re: Books for experienced DB developer
  41. Re: Books for experienced DB developer
  42. Books for experienced developers
  43. Re: Query, view join question.
  44. Re: Global/persistent variables
  45. Query, view join question.
  46. Editor: Syntax highlighting and stored procedures surrounded by '
  47. Question about varchar and text
  48. unsubscribe
  49. Re: Question about varchar and text
  50. ltree valid characters
  51. Serial Foreign Key
  52. question about plpythonu
  53. pg_dump dependencies
  54. DBMS_File Equivalent?
  55. Re: Query, view join question.
  56. Re: Editor: Syntax highlighting and stored procedures surrounded
  57. functions in postgresql
  58. Global/persistent variables
  59. Re: Query, view join question.
  60. Re: Question about varchar and text
  61. Re: pg_dump dependencies
  62. postgresql-contrib risks?
  63. function corresponging to over in db2
  64. Re: SELECT WHERE NOT, is not working
  65. warning: pg_query(): Query failed
  66. problem finding the 8.0.3RC download
  67. multi column index and order by
  68. Happiness is a cross database link...
  69. Re: Happiness is a cross database link...
  70. Index on a view??
  71. Re: Index on a view??
  72. Re: Index on a view??
  73. SELECT WHERE NOT, is not working
  74. Trigger Question
  75. Re: Trigger Question
  76. Re: SELECT WHERE NOT, is not working
  77. Re: problem finding the 8.0.3RC download
  78. Re: multi column index and order by
  79. Re: warning: pg_query(): Query failed
  80. Re: warning: pg_query(): Query failed
  81. Passing a ROWTYPE to a function
  82. calculating costs.
  83. vacuum is failing
  84. Re: hundreds of millions row dBs
  85. PostgreSQL users on webhosting
  86. PostgreSql replication with heterogeneous databases!
  87. changing column from int4 to int8, what happens with indexes?
  88. varchar vs text
  89. Re: hundreds of millions row dBs
  90. hundreds of millions row dBs
  91. Mailwatch postgresql support ?
  92. Re: Can't change password?
  93. C function taking a relation and returning a similar relation.
  94. Re: Generating unique values for TEXT columns
  95. Generating unique values for TEXT columns
  96. PostgreSQL 8.0.0 RC3 RPMs for SUSE LINUX
  97. help with a stored procedure
  98. Can't find relation oid
  99. Merging Data from Multiple DB
  100. function in postgres
  101. Joined delete
  102. Index, Tablespace and performance
  103. Re: Select number of children of a parent query
  104. OS X shared memory problems 8.0rc3
  105. Re:
  106. Shared Sequences?
  107. PostgreSQL 8.0.0 Release Candidate 3
  108. citext datatype
  109. Question on a select
  110. Function Parameters
  111. many similar indexbased selects are extremely slow
  112. Re: ECPG Segfaulting on EXEC SQL connect
  113. Re: pgodbc error
  114. 'distinct on' and 'order by' conflicts of interest
  115. Re: [PATCHES] reqd patch
  116. Can't change password?
  117. Can you use an array of variables in a function?
  118. Re: [PATCHES] reqd patch
  119. Re: Large Objects
  120. Re: Tracking back foreign keys?
  121. Re: looking for connection leaks
  122. pgodbc error
  123. using pg_config to get LDFLAGS?
  124. vaccum db fail
  125. ECPG Segfaulting on EXEC SQL connect
  126. postgresql 8.0 Rc1
  127. Recursive update
  128. postgresql 8.0 rc1
  129. Postgresql website issues.
  130. syntax for inserting unicode character literal
  131. possible to DELETE CASCADE?
  132. Update rule
  133. Roadmap for Database Kernel XA Support
  134. Fwd: Advice on moving rows to history
  135. WARNING: group with ID NNN does not exist
  136. Advice on moving rows to history
  137. debug_print_plan (pg7.4) doesn't seem to do anything
  138. pg_dump and pgpool
  139. Re: BCD format
  140. BCD format
  141. pgsql question
  142. Re: 8.0 Beta3 worked, RC1 didn't!
  143. FW: 8.0 Beta3 worked, RC1 didn't!
  144. Re: running a query file of 42MB
  145. Re: Get current trasanction id
  146. Re: running a query file of 42MB
  147. running a query file of 42MB
  148. Long-running performance (MVCC, Vacuum, etc.) - Any fix?
  149. error : syntax error at or near $1 for over select rows
  150. 8.0 Beta3 worked, RC1 didn't!
  151. Re: Get current trasanction id
  152. Where is the error
  153. 8.0 rc2 Problem
  154. Merry Christmas
  155. Re: [sfpug] Basic problem installing TSearch2 (full text
  156. Re: default index for primary key of a table
  157. win32 installer problem
  158. Re: 8.0 Beta3 worked, RC1 didn't!
  159. loading only few rows from huge table
  160. Making a varchar bigger
  161. Caching/Indexing Function Output
  162. update table with row locking
  163. Re: monitoring tools
  164. select as
  165. 8.0 Beta3 worked, RC1 didn't!
  166. Re: monitoring tools
  167. Re: monitoring tools
  168. monitoring tools
  169. Re: bytea
  170. Very slow stored proc
  171. Basic problem installing TSearch2 (full text search)
  172. Re: migrating from mysql
  173. migrating from mysql
  174. converting unique index into primary key
  175. duplicate msgs when delivery through commandprompt.com
  176. Memory Errors OS X
  177. Re: 8.0 Beta3 worked, RC1 didn't!
  178. Re: Strange Index behavior
  179. Re: nice work on the new site
  180. AREs in substring(from)
  181. valid using INITIALLY DEFERRED
  182. postgresql.conf
  183. Re: PostgreSQL training curriculum
  184. Strange Index behavior
  185. default index created for primary key
  186. SQL query question
  187. Problem with Select output
  188. Re: 8.0 Beta3 worked, RC1 didn't!
  189. replicator
  190. PostgreSQL 8.0.0 Release Candidate 2
  191. 8.0 Beta3 worked, RC1 didn't!
  192. ANNOUNCE: DBD::Pg 1.40 release candidate 1 request for testing
  193. tool for incrementally shrinking bloated tables
  194. PostgreSQL training curriculum
  195. New Fedora 3 install gives: relation "pg_catalog.pg_user" does notexist
  196. Problem with database
  197. ISO_8859_8 encoding
  198. DELETE versus TRUNCATE during pg_dump....
  199. RES: RES: NewsForge Poll: Favorite open source database?
  200. RES: NewsForge Poll: Favorite open source database?
  201. Create a cache DB between web portal and internal DB?
  202. Need help to organize database
  203. transactions in multiple action rules
  204. problems with date
  205. weird run-times with pg_autovacuum
  206. Installing postgres 8 using Remote Desktop Connection
  207. Short circuit operations in plpgsql?
  208. Re: Scheduler in Postgres
  209. Problems with pg_restore
  210. Diskspace
  211. Re: RES: NewsForge Poll: Favorite open source database?
  212. Re: readline configure error again
  213. pgjob registered on pgFoundary
  214. Israel Go-Linux conference
  215. A "cascade on delete" constraints deletes AFTER the source is gone??
  216. PG8 final when
  217. could not access file $libdir...
  218. Make a query faster...
  219. could not read block 84253 of relation "tablename": Input/outputerror
  220. Re: Connect to Postgres 7.4 via ODBC SOLVED!!!!!
  221. BTree max row size?
  222. Multi row sequence?
  223. NewsForge Poll: Favorite open source database?
  224. Contacting Tom Lane :)
  225. Re: Scheduler in Postgres
  226. Re: Check if table exists
  227. MD5(MD5(pw)) OK?
  228. unix_socket_directory
  229. Re: analyze-error: "cannot compare arrays of different element types" revisited
  230. Re: analyze-error: "cannot compare arrays of different element types" revisited
  231. replacements for vacuum?
  232. OSX 10.3.7 broke Postgresql 8.0.0b5?
  233. unsubscribe pgsql-general
  234. unsubscribe pgsql-general
  235. (NONE)
  236. Problem with pl/perl in postgresql 8.0rc1
  237. Re: Trigger: what rows were deleted?
  238. Trigger: what rows were deleted?
  239. Debian PLPython
  240. sorting problem
  241. MD5
  242. tsearch2 avoiding firing of triggers.....
  243. Non-aggregate values attached to aggregates?
  244. Re: pl/pgsql oddity
  245. Re: pl/pgsql oddity
  246. Re: pl/pgsql oddity
  247. 7.1.3: dataloss: FATAL 2: XLogFlush: request is not satisfied
  248. What HW / OS is recommeded
  249. DB Slowing Down
  250. Serial column has suddenly stopped working