PDA

View Full Version : Pgsql General

  1. compilation postgresql/solaris error
  2. Howto repair template1
  3. renumber id's in correct order (compact id's)
  4. Scripting issues
  5. HELP!!! Corrupt Database!
  6. dealing with file size when archiving databases
  7. problems with types after update to 8.0
  8. users, address record restrictions
  9. Information retrieval
  10. pg_hba problem
  11. error during pg_dump
  12. Odd performance issue
  13. Re: plpgsql constraint checked data fails to restore
  14. Why can't I install in a terminal session?
  15. Re: OIDS
  16. OIDS
  17. Re: Help! What has changed in the internal structure of PostgreSQL?
  18. Help! What has changed in the internal structure of PostgreSQL?
  19. (2) failed to find conversion function from "unknown" to ...
  20. restore large database
  21. failed to find conversion function from "unknown" to ...
  22. External (asynchronous) notifications of database updates
  23. plpgsql constraint checked data fails to restore
  24. unicode and =
  25. Insert behavior in transaction
  26. subqueries
  27. user/groups query ?
  28. Sort Ignoring Spaces
  29. Anyone use pgcluster in production?
  30. ALTER FUNCTION semantics
  31. PgAdmin 1.2.2 on MacOS X with PG 8.0.3
  32. Replication
  33. Error defining composite types and returning ROWTYPEs
  34. Replication
  35. Deleting a rule?
  36. Error column "sys" does not exist
  37. Access is denied during initdb
  38. 再びお伝えします。
  39. Change to make strings SQL-standard
  40. PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms
  41. Re: pg_dumpall
  42. Experiencing problems with stored procedures
  43. query plan in pg7.4 vs 8.0.3
  44. Making the DB secure
  45. Foreign key to a view (UNION of two or more tables), any alternative?
  46. Backing up multiple databases
  47. Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM
  48. encoding problems and float
  49. psql: FATAL: database "template1" is not currently accepting connections
  50. Advice on structure /sequence / trigger
  51. Viewing non-system objects in psql
  52. Re: pg_dumpall
  53. Extremely slow performance with 'select *' after insert of 37,000records
  54. is this a bug ?
  55. Multiple COPYs
  56. pgavd status
  57. pg_restore won't create database
  58. Help: chinese character set support (EUC_TW to/from BIG5 conversion)
  59. Hungry postmaster
  60. PostgreSQL log analyzer
  61. Dynamic SQL
  62. pg_dumpall
  63. Could not open service manager
  64. DATATYPE for HEX
  65. Executing SQL Script
  66. Installation on latest version of Suse Linux
  67. Re: graphic client
  68. graphic client
  69. plpgsql - TIMESTAMP variables in EXTRACT
  70. plpgsql cursors, fetching more than one row
  71. vacuumdb suggestions?
  72. PostgreSQL Client Aplications ?
  73. enebling regular user to create new users ?
  74. retrieving information about users and groups
  75. changing the sequence for a table
  76. 8.03 postgres install error
  77. Postgresql performance on Opteron 8 CPU
  78. Reporting tools
  79. slow parsing of queries with joins
  80. Consultants
  81. Deadlock Problem
  82. Best approach setting up PostgreSQL
  83. メウ髟阡札標魎孔踉捌由
  84. Database became very slow(Help PLS)
  85. Current transaction ID?
  86. Bad pg_xlog with no redo
  87. user groups
  88. Re: Set Membership operator -- test group membership
  89. How to set an expiration date for a WHOLE user account
  90. Re: Set Membership operator -- test group membership
  91. Set Membership operator -- test group membership
  92. server not starting
  93. ilike, ~*, ~~* does not work on 8.0.3 (db encoding - UNICODE)
  94. Re: duplicate key violates unique constraint
  95. Strange Create function behavior
  96. suse 9.2
  97. Announcing dataKiosk version 0.7
  98. Hash Function: MD5 or other?
  99. Re: [HACKERS] mirroring oracle database in pgsql
  100. Re: return next and pl/perl
  101. postgresql rpms (7.4.2, 7.4.5, 7.4.8) for redhat 8.0
  102. Index problem
  103. PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
  104. Will the optimizer eliminate an unnecessary sort?
  105. pg_dumpall not working?
  106. Index does not working.
  107. New to Postgre
  108. md5 autentication error
  109. Re: mirroring oracle database in pgsql
  110. invalid message length
  111. LOG: invalid message length
  112. duplicate key violates unique constraint
  113. Re: Case sensitivity
  114. Postgres 8.1
  115. (NONE)
  116. Re: retrieving information about password from MS
  117. users,groups and permissions
  118. Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
  119. Re: Use of Indexes
  120. Re: Case sensitivity
  121. Re: Trying to get posgreSQL-8.0.3 up on Tiger 10.4.1
  122. Case sensitivity
  123. CVS stability
  124. Re: memory question
  125. memory question
  126. tsearch2 and a database with texts in different languages?
  127. funny update, say update 1, changed 2 records.
  128. return next and pl/perl
  129. 理解を頂く為・瘢雹・瘢雹・瘢雹
  130. Waiting for select
  131. Re: index xyz is not a btree
  132. PostgreSQL Certification
  133. index xyz is not a btree
  134. foreign key constraint not being respected with type created by CREATE TYPE
  135. 8.0 Install issues
  136. postgres and xml
  137. Deletes and large tables
  138. Re: return two elements
  139. Open Source database comparison
  140. Re: [SQL] Permission denied for language pltclu
  141. Re: [SQL] Permission denied for language pltclu
  142. Re: [SQL] Permission denied for language pltclu
  143. Inherits and "get highest id".
  144. Re: how do you set foriegn keys in pgaccess?
  145. Permission denied for language pltclu
  146. IMPORTANT NOTIFICATION
  147. FATAL: Sorry, too many clients already????
  148. Wrong select results after transaction (HELP PLS)
  149. INHERITS and planning
  150. Setting all elements in an Bool[] array to the same value
  151. Now() function
  152. Pushing limit into subqueries of a union
  153. Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
  154. Version Control?
  155. ERROR: cannot cast type text to bit varying
  156. monetary data
  157. Re: Postgresql fails to start? (Update)
  158. Re: postgreSQL 7.3.8, pg_dump not able to find large o
  159. Re: Starting PostgreSQL on WinXP is not working
  160. Starting PostgreSQL on WinXP is not working
  161. "returning" in postgresql request
  162. Propogating conditions into a query
  163. Re: vulnerability/SSL
  164. Re: vulnerability/SSL
  165. Re: vulnerability/SSL
  166. Pb with linked tables on PG8
  167. Postgre "idle" process using 100% CPU
  168. how do you set foriegn keys in pgaccess?
  169. Possible to ignore transactions > n?
  170. Re: Deleting orphaned records to establish Ref Integrity
  171. postgres and ggobi/xgvis
  172. Re: IMPORTANT NOTIFICATION
  173. WinXP installation
  174. So maybe SQLERRM? Sb knows how to check it?
  175. Two updates problem
  176. deadlocks in multiple-triggers environment
  177. Foreign keys and slow insert
  178. Bug with view definition?
  179. Re: vulnerability/SSL (fwd)
  180. Optimizer and inherited tables
  181. FW: Where to find translation of Postgres error messages?
  182. Re: vulnerability/SSL
  183. vulnerability/SSL
  184. Copying data from int column to array column
  185. Backup Compatibility between minor versions.
  186. Where to find translation of Postgres error messages?
  187. Re: return two elements
  188. Postgres 8.0.1 configure failed
  189. blocking INSERTs
  190. Reliably finding temporary table
  191. To SPAM or not to SPAM...
  192. Re: Things I learned about PG8 on AIX5.3 with XLC compiler
  193. pl/pgsql list
  194. Things I learned about PG8 on AIX5.3 with XLC compiler
  195. Re: locking question - why is this not a deadlock?
  196. Issue with adding ORDER BY to EXCEPT.
  197. 再びお伝えします。
  198. Debian Stable goes from Woody to Sarge!!
  199. Problem with catching my own exception messages.
  200. Recovery when old WAL segment has been overwritten?
  201. how to loop until eof in a cursor with pgsql
  202. Password authentication failed for user
  203. Update sql question
  204. CHAR LIKE VARCHAR
  205. Re: return two elements
  206. Re: return two elements
  207. how to get sequence list ?
  208. Postgresql fails to start?
  209. db corruption/recovery help
  210. Logging query plan for queries
  211. which commands under PostgreSQL do the similar func provided by "showprocesslist" under mysql
  212. Re: CPU-intensive autovacuuming
  213. return two elements
  214. pg_dump 8.0.3 failing against PostgreSQL 7.3.2
  215. Re: Large Object => invalid input syntax for integer: ""
  216. transactions
  217. Large Object => invalid input syntax for integer: ""
  218. Fyracle?
  219. Re: writting a large store procedure
  220. Download mirrors not found?
  221. CPU-intensive autovacuuming
  222. Getting the Type Definition in the information schema
  223. SELECT DISTINCT performance issue
  224. Re: How do I reinstall libeay32.dll
  225. Re: How do I reinstall libeay32.dll
  226. How do I reinstall libeay32.dll
  227. Preventing Multiple Inheritance
  228. postgresql books
  229. Referencing Serial Type as Foreign Key
  230. Test for array slice?
  231. PG Lightning Admin running on Linux via WINE 2005524
  232. Re: Automate Postgres Backup In windows -> resolved
  233. Re: PostgreSQL Developer Network
  234. Re: [SQL] index row size 2728 exceeds btree maximum, 27
  235. Re: Automate Postgres Backup In windows
  236. Re: Using pg_dump in a cron
  237. Re: SQL call to get pid of current connection
  238. PostgreSQL vs. InnoDB performance
  239. Re: SQL call to get pid of current connection
  240. SQL call to get pid of current connection
  241. adding columns with defaults is not implemented
  242. Limits of SQL
  243. Automate Postgres Backup In windows
  244. Using pg_dump in a cron
  245. Determining when a row was inserted
  246. Re: [SQL] index row size 2728 exceeds btree maximum, 2713
  247. Automate Postgres Backup In windows
  248. Re: Stats not getting updated....
  249. Re: index row size 2728 exceeds btree maximum, 2713
  250. writing a file using procedure