View Full Version : Pgsql General



  1. Dynamic loading of C functions
  2. Re: [INTERFACES] help with error message from perl Pg
  3. Exporting data from view
  4. question about performance of libpq
  5. Help requd in writing functions in C and using in Postgres
  6. question about performance of libpq
  7. Re: help with error message from perl Pg
  8. Interface Guidance and Opinions Needed
  9. merge result sets
  10. Why my cursor construction is so slow?
  11. best way to get PKey and FKey from inside applications (permission pb)
  12. Start up question about triggers
  13. DocBook 4.2 detecting at configure time
  14. dynamic sorting...
  15. Fwd: Re: problem connecting to server
  16. join on next row
  17. Re: Computing transitive closure of a table
  18. Database Clustering on multiple harddisk
  19. incremental backup?
  20. psql for winxp?
  21. Cannot restart postgres
  22. Computing transitive closure of a table
  23. simple query terminated by signal 11
  24. Changing encoding of a database
  25. How to build with bigger WAL segment file?
  26. SELECT statement takes 10 minutes to answer
  27. BackUp
  28. problem connecting to server
  29. Re: Question about openSSL
  30. Adding foreign key constraints without integrity check?
  31. getting comment about constraint
  32. Changing array subscripting to zero-offset
  33. SQL query question
  34. MySQL insert() and instr() equiv
  35. Question about openSSL
  36. phppgadmin 4.0.1
  37. problem in loading a jar file
  38. Regarding data recovery
  39. Online backups and tar
  40. (no subject)
  41. How to install PL/perlU (perl untrusted)
  42. PL/Perl questions...
  43. Re: VACUUMing sometimes increasing database size / sometimes
  44. Re: VACUUMing sometimes increasing database size / sometimes
  45. Re: postgres and ldap
  46. Re: VACUUMing sometimes increasing database size / sometimes
  47. Re: postgres password
  48. Forcing backslash to be treated as ordinary string character
  49. Re: VACUUMing sometimes increasing database size / sometimes
  50. minimizing downtime when upgrading
  51. Omitting tablespace creation from pg_dumpall...
  52. postgres and ldap
  53. Question about clustering multiple columns
  54. Forcing backslash to be treated as ordinary string character
  55. postgres and ldap
  56. How to optimize PostgreSQL database size
  57. table has a many to many relationship with itself ... ?
  58. need help to recover database
  59. query optimizer
  60. Re: postgres password
  61. Partitioning and sub-partitioning problems
  62. SOLVED: Re: UTF-8 and stripping accents
  63. pgadmin window closes abnormally
  64. postgres password
  65. VACUUMing sometimes increasing database size / sometimes crashing it
  66. Re: VACUUMing sometimes increasing database size / sometimes crashing it
  67. UTF-8 and stripping accents
  68. A few questions about carriage returns (\r)
  69. Annoying "could not find a "psql" to execute" message
  70. Relation "tablename" does not exist
  71. how pg_hba.conf
  72. how to test my stored procedures?
  73. tsearch2
  74. DEFAULT_STATISTICS_TARGET
  75. Re: table has many to many relationship with itself - how
  76. Performance Question
  77. Out of memory error in 8.1.0 Win32
  78. Initdb logging on xp
  79. new user (need help: fedora core 4)
  80. Re: Problem Connecting to 5432
  81. Copy content from dbs
  82. Compiling contrib dblink_tds and oralink
  83. table has many to many relationship with itself - how to implement?
  84. Problem Connecting to 5432
  85. MAX() across partition tables
  86. Short circuit evaluation of expressions in query
  87. plpgsql Result Sets
  88. More on state variables
  89. PostgreSQL and Apache: authentication and authorization
  90. XID comparations
  91. Cant' create language - "could not load library"
  92. PostgreSQL and Apache
  93. A slow query
  94. Error: Server doesn't listen
  95. Searching BLOB
  96. Re: ECPG and Curors.
  97. Help speeding up this query - maybe need another index?
  98. ECPG and Curors.
  99. Aggregate functions not allowed in WHERE clause
  100. How can I retrieve a function result?
  101. Partitioning...
  102. BLOB & Searching
  103. pg_dump: missing pg_database entry
  104. Best security practices for installing pgSQL with my software
  105. test
  106. delete seems to be getting blocked
  107. Help with storing spatial (map coordinates) data?
  108. GnuPG / PGP signed checksums for PostgreSQL 8.1.4, 8.0.8, 7.4.13, and 7.3.15
  109. Re: Pgpool-committers unsubscribe notification
  110. can i use a string in where clause such as "id in (str)"
  111. Disk corruption detection
  112. Ever increasing OIDs - gonna run out soon?
  113. Invitation to EuroPython conference
  114. are there static variables in pgsql?
  115. Questions about indexes
  116. TOAST not working
  117. TOAST not working
  118. Re: pgxml & xpath_table
  119. Access for Postgresql?
  120. Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does
  121. State of Postgresql Replication?
  122. not valid character for Unicode
  123. Problem with silent install of PgSQL on Windows
  124. 010.pgsql.sh does not react
  125. OID
  126. Manual Installation of PostgreSQL on Windows
  127. error 57014
  128. Problems with database bloat
  129. psql command and file size
  130. php 5.1.4 with PostgreSQL 8.1.4 causes Apache 1.3.36 to core dump
  131. Re: UTF8 problem
  132. ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
  133. Out of Memory Error on Postgresql 8.1.3. on win32
  134. Password for postgresql superuser?
  135. Any *real* reason to choose a natural, composite PK over a surrogate, simple PK?
  136. Fabian Pascal and RDBMS deficiencies in fully implementing the relational model
  137. FW: Connection Error
  138. UTF8 problem
  139. Re: date value not geting inserted properly
  140. A web based rewards management system for philip.immirzi@yahoo.co.uk
  141. log_duration - exactly what does it measure?
  142. PG Lightning Admin and Linux
  143. SessionID, pretty please
  144. Backslash problems with 8.1.4
  145. Re: Can PostGreSQL slow down a Windows PC much?
  146. Can PostGreSQL slow down a Windows PC much?
  147. What are the characteristics of a good user-defined data type?
  148. Re: Import Data from MS SQL Server
  149. Action Table of postgresql
  150. composite data type question
  151. Problem with 'postgres' db with 8.0 on a MacBook
  152. What are the characteristics of a good user-defined data type
  153. Some mystery with execution plans on postgres 8.1
  154. Import Data from MS SQL Server
  155. help with rules please
  156. Problems copying data to different database
  157. ean code data type
  158. Plpgsql Multidimensional array
  159. Data about rate of downloads
  160. Re: [pgsql-advocacy] Me And My Database
  161. Trigger function to audit any kind of table
  162. autovacuum, xid wraparound, pg_database column values
  163. Backwards index scan
  164. high %system time
  165. Re: How to use index in case insensitive substing search
  166. How to use index in case insensitive substing search
  167. Problem with postgresql-docs-8.1.4-1PGDG.i686.rpm
  168. 7.3.3, Fedora Core 5, test geometry and test horology
  169. Re: php 5.1.4 w/ PostgreSQL 8.1.4
  170. php 5.1.4 w/ PostgreSQL 8.1.4
  171. Is it a big deal to change the user the DB runs under?
  172. COLLATE
  173. Re: Installing PostGreSQL automatically
  174. FW: Installing PostGreSQL automatically
  175. Best way to store and retrieve large objects in database for email program
  176. Re: Installing PostGreSQL automatically
  177. PROBLEM windows postgres installation
  178. Accessing output parameters from my program?
  179. Error during installation postgres on windows
  180. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  181. What is the point of create or replace view command
  182. Re: 8.1.4: Installation ends up in endless recheck loops
  183. Case for postgreSQL
  184. does this mean i have a corruption?
  185. Can't get pgsql 8.1.4 to password protect roles.
  186. Performance difference between char and int2 columns
  187. Re: psql: krb5_sendauth: Bad application version was sent (via sendauth) - Windows 2000, MIT Kerberos, PG v 8.1.1
  188. Using postgresql as desktop DB
  189. Re: psqlodbc problem Urgent
  190. New version of DBD::Pg for 8.1.4?
  191. How to do a "CREATE DATABASE" and then connect to it?
  192. Postmaster shuts down after rebuilding database via psql
  193. Migrate Postgres 7.2 to Postgres 8.1
  194. Reinstalling Postgres 8.1 on Window problem
  195. Querying for strings that match after prefix
  196. create view problem
  197. review SQL command history?
  198. help me on a trigger
  199. Getting "timeout expired" error almost immediately (20-200ms)
  200. Problem adding a record with vb6
  201. Re: Best open source tool for database design / ERDs?
  202. Re: Problem in Pg 8.1.4 with CREATEDB
  203. PostgreSQL authentication as my application's authentication.
  204. Is there a database file system?
  205. Re: Fat 32/NTFS
  206. Fat 32/NTFS
  207. postgres in windows
  208. Java Triggers
  209. Re: Problem V8.1.4 - providing pwd for commandline tools doesn't
  210. Re: Problem in Pg 8.1.4 with CREATEDB
  211. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  212. GPL Licensed Files in 8.1.4
  213. strange stable function behavior
  214. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  215. how to create an insert query from PGresult (libpq-fe.h)
  216. command line
  217. importing data
  218. Re: Synchronizing tables
  219. Moving Postgres Database
  220. problemas con psql -l
  221. pg_depend question
  222. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  223. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  224. The best way connecting.
  225. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  226. CreateUser error
  227. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  228. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  229. Synchronizing tables
  230. Re: PGSQL 7.4 -> 8.1 migration & performance problem
  231. Re: Best high availability solution ?
  232. A quick question on CONTRIB package
  233. Re: Problems posting messages in this mailing-list?
  234. Re: Problems posting messages in this mailing-list?
  235. Re: Best high availability solution ?
  236. Re: Best high availability solution ?
  237. Re: Best high availability solution ?
  238. Re: Best high availability solution ?
  239. Re: Best high availability solution ?
  240. Re: Best high availability solution ?
  241. Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore
  242. Best high availability solution ?
  243. Problem in Pg 8.1.4 with CREATEDB
  244. How to link database A in server X to database B in server Y?
  245. Re: Which RPM for RH Linux ES 4? PGDB or RH?
  246. SCSI disk: still the way to go?
  247. Re: UTF-8 context of BYTEA datatype??
  248. Re: UTF-8 context of BYTEA datatype??
  249. Re: [HACKERS] Schema Limitations ?
  250. Re: Which RPM for RH Linux ES 4? PGDB or RH?