PDA

View Full Version : Pgsql General

  1. Re: PostgreSQL + hibernate
  2. Re: PostgreSQL + hibernate
  3. verifying database integrity - fsck for pg?
  4. Re: [HACKERS] New project launched : PostgreSQL GUI
  5. PostgreSQL + hibernate
  6. New Edition of Date/Darwen's The Third Manifesto
  7. Can't get the field = ANY(array) clause to work...
  8. Re: regarding debugging?
  9. I need some info on repairing database corruption
  10. pg 8.1.2 ERROR: direct correlated subquery unsupported as initplan
  11. Insert rate drops as table grows
  12. WinXP install question
  13. Rotation of security logs in Postgres 7.4.11
  14. Re: Access Problem After Version Upgrade -- Update
  15. pg 8.1.2 ERROR: direct correlated subquery unsupported as initplan
  16. Transaction safety and large objects. Possible?
  17. FW: Schema with Postgress 8.1
  18. 8.0.3 regexp_replace()...
  19. How to change the default database for a user
  20. How to define variables in psql scripts?
  21. Little Offtopic: Database frontends
  22. schema rename sequence issue
  23. Re: postgresql performace degrading after a while
  24. postgresql performace degrading after a while
  25. Indexes
  26. =?iso-2022-jp?B?GyRCRn42YiRyJDUkOyRGRDokLSReJDskcyQrISkbKEI=? =
  27. help
  28. Re: Viewing Database Scheme
  29. Seeking a better PL/pgSQL editor-debugger
  30. Viewing Database Scheme
  31. creating users per database
  32. Re: Importing Many XML Records
  33. Re: Importing Many XML Records
  34. Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes
  35. Postgres 8.1.2, Java, JDO, and case sensitivity woes
  36. SQL Lint
  37. Basic questions about PQprepare()
  38. parameter substitution problem in jdbc driver? (8.1)
  39. Are rules transaction safe?
  40. Re: xml_valid function
  41. WAL questions
  42. Importing Many XML Records
  43. Allowing Custom Fields
  44. Re: TSearch2 / German compound words / UTF-8
  45. Re: TSearch2 / German compound words / UTF-8
  46. Finding missing records
  47. REPOST:Memory Allocation error using pg_dump on 7.4
  48. PG_RESTORE and database size
  49. Change SERIAL to INTEGER
  50. Logging statements and parameter values
  51. Accessing an old database from a new OS installation.
  52. question about large databases
  53. Error: "could not read from statistics collector pipe"
  54. (NONE)
  55. =?iso-2022-jp?B?GyRCOEJEaiM1IzA/TSROMnEwd01NJEtBdz8uJDUkOyRGRDokJCRGGyhC?=
  56. What Could Cause This Behavior?
  57. SYNTAX ERROR at or near SQLSTATE
  58. "xmin" system column
  59. VACUUM Question
  60. Fw: Arrays
  61. How to implement nested transactions
  62. Arrays
  63. Encoding errors when upgrading from 7.4 to 8.1
  64. Suggestions on storing and retrieving geocode data
  65. incremental backups
  66. Hey!!!
  67. EXCEPTION Function
  68. Access Problem After Version Upgrade
  69. comparing OLD and NEW in update trigger..
  70. locale - polish, poland
  71. many row updates
  72. Re: Missing database entry in pg_database
  73. comparing OLD and NEW in update trigger..
  74. Which table(s) in the catalog define the tables and views?
  75. Wiki Site for the PostgreSQL Newbie
  76. xml_valid function
  77. Implimenting an XPath engine in PostgreSQL / Staircase Join
  78. pgstattuple output?
  79. Trigger question: ROW or STATEMENT?
  80. xml support on win32 postgres
  81. filtering after join
  82. My very first PL/pgSQL procedure...
  83. Alternative to knoda, kexi and rekall?
  84. Missing database entry in pg_database
  85. 2 instances of postmaster with different data directories
  86. Re: FATAL: terminating connection due to administrator command
  87. Tsearch 2
  88. table is not a table
  89. Temporary table visibility
  90. Re: Shared Database across multiple servers using OCFS2
  91. Please, help! About database cluster and adding to it additional disk space
  92. Shared Database across multiple servers using OCFS2
  93. Re: hi all......................!!
  94. Postgresql Segfault in 8.1
  95. pgxml
  96. Re: Installing Postgres 8.1 on Windows Server 2003 R2
  97. FATAL: invalid frontend message type 47
  98. Interpreting pg_locks; looking for deadlock
  99. Constraint that compares and limits field values
  100. Re: Quoted NULLs with COPY FROM (and pgAdmin export data options)
  101. Access a temporary table of another session - is it possible ?
  102. Re:
  103. Re: Does this look ethical to you?
  104. Re: Does this look ethical to you?
  105. Re: Does this look ethical to you?
  106. user defined function
  107. Re: Does this look ethical to you?
  108. PostgreSQL best practices?
  109. Re: Does this look ethical to you?
  110. Re: Does this look ethical to you?
  111. Re: Does this look ethical to you?
  112. Problems with pgsql 8.0.4 & freebsd 6: partially solved
  113. NOT HAVING clause?
  114. execution plan : Oracle vs PostgreSQL
  115. Re: Does this look ethical to you?
  116. Re: Does this look ethical to you?
  117. Re: FATAL: terminating connection due to administrator command
  118. Re: Does this look ethical to you?
  119. Re: Quoted NULLs with COPY FROM
  120. Does this look ethical to you?
  121. Quoted NULLs with COPY FROM
  122. Re: Installing Postgres 8.1 on Windows Server 2003 R2
  123. ANN: Bricolage 1.10
  124. Fedora and pgadmin3
  125. Re: Linux - postgres RAID
  126. Are indexes used with LIKE?
  127. Linux - postgres RAID
  128. ROLLBACK triggers?
  129. Full Text Indexing Using Tsearch2-Module
  130. Transact SQL compatibility layer
  131. Combine, Merge, Concatenate
  132. Re: DBMirror.pl performance change
  133. Re: DBMirror.pl performance change
  134. Postgresql/DBA/Sysadmin Consultant in =?iso-8859-1?q?D=FCsseldorf?=, Germany
  135. What is made a mistake with SP?
  136. Re: logging connections
  137. invalid memory alloc request size
  138. Re: logging connections
  139. Does pg_dump have result codes to indicate success or failure
  140. joining tables
  141. Numbers
  142. Memory Allocation error using pg_dump on 7.4
  143. Working out diskspace taken by database and tables 7.4
  144. Re: [HACKERS] Need help in installing postgresql 8.1.2 on Windows
  145. optimizing server for a 10 million row table
  146. numeric data type?
  147. Re: Is there a way to list running queries
  148. Is there a way to list running queries
  149. standard normal cumulative distribution function
  150. Strange errors after some DB problems
  151. panic on 7.3
  152. panic on 7.3
  153. Page-Level Encryption
  154. Re: What is the maximum length of an IN(a,b,c....d) list in PostgreSQL
  155. sequences not restoring properly
  156. what am I doing wrong with this query?
  157. Creation of tsearch2 index is very slow
  158. Re: How to convert Big5 to UTF8
  159. How to fetch rows with multiple values
  160. Re: out parameters and SETOF
  161. autovacuum and temporary tables
  162. logging connections
  163. R: JDBC query creates a suspended Linux process
  164. Re: create plperlu langage fails
  165. Initdb panic: invalid record offset at 0/0 creating template1]
  166. Re: create plperlu langage fails
  167. Bizgres 0.8 vs. 8.1.2
  168. psql: FATAL: password authentication failed for user "xxxx"
  169. Create User
  170. Re: Using rowtype parameter
  171. Connected user in a triggerfunction
  172. Re: auto increment within a compound key
  173. Privilege for seeing queries using pg_stat_get_backend_activity
  174. create plperlu langage fails
  175. PostgreSQL - a ORDBMS?
  176. Re: Windows re-installation problem
  177. GBorg as a spam magnet
  178. Normalized storage to denormalized report
  179. Insert a default timestamp when nothing given
  180. tsearch2 and "how to use"
  181. Isolation level in a function
  182. mount -o async - is it safe?
  183. using SSL client certs?
  184. Re: [BUGS] Execution of stored procedures
  185. How to log full substituted queries?
  186. \s tail?
  187. Data type that corresponds to bigserial...
  188. RAID-50
  189. Re: [HACKERS] No heap lookups on index
  190. Re: [HACKERS] No heap lookups on index
  191. Problem with Timestamp
  192. Rollback to Previous Version
  193. 32/64 architectures for backup/WALs
  194. Updating rows (automatically) that are selected
  195. Postgres Wierdness
  196. Dates
  197. latest HISTORY file
  198. bigger blob rows?
  199. JDBC query creates a suspended Linux process
  200. Stored Procedues in C
  201. RAID 5 and postgresql
  202. Connections not closing
  203. Re: Change owner of all database objects
  204. Re: Change owner of all database objects
  205. Image in postgresql 7.3
  206. Error Starting postmaster.exe (8.1.2-1) on XP - GPF
  207. Partitioning: Planner makes no use of indexes on inherited table?!
  208. Re: PostgreSQL Top 10 Wishlist
  209. SELECT Rules or stored procedure
  210. Modify the password of the service account?
  211. Text field performance
  212. Windows re-installation problem
  213. pg_dump throws no buffer space available error
  214. prepared statement results don't clear?
  215. Indexes
  216. mac os x compile failure
  217. Replicating a remote database (backuping)
  218. Rule problem: return value of insert
  219. Change owner of all database objects
  220. Distance calculation
  221. Re: A tale of two similar databases
  222. Re: About Full-text searching under postgresql
  223. Permission denied on relation
  224. About Full-text searching under postgresql
  225. full text search
  226. tablespace and pg_dump
  227. general questions about joins in queries
  228. linking temporary tables from MS Access?
  229. Is there a way to list runaway queries and kill them?
  230. A tale of two similar databases
  231. Stored procedures..PLEASE HELP
  232. Re: Strange error while executing query from front end:
  233. Strange error while executing query from front end:
  234. Re: Strange error while executing query from front end:
  235. ODBC MSAccess
  236. Re: Plans for 8.2?
  237. Ref cursor with Geometric Function
  238. lists all users under groups
  239. Huge number of disk writes after migration to 8.1
  240. Real-time TB databases (not PostgreSQL related)
  241. Create/Erase 5000 Tables in PostGRE SQL in execution Time
  242. Create/Erase 5000 Tables in PostGRE SQL in execution Time
  243. Re: Plans for 8.2?
  244. temporary tables, pgAdminIII
  245. Rule system and unsucessful updates.
  246. Zonder moeite 5000,- Euro verdienen in 2 weken tijd
  247. visual query builder for Postgres?
  248. Fwd: Re: sort character data in arbitrary order?
  249. join table design question
  250. Upgrading 8.1.1 to 8.1.2 in Windows