PDA

View Full Version : Pgsql General

  1. Re: [pgsql-advocacy] European users mailing list
  2. Possible new feature
  3. Re: [pgsql-advocacy] European users mailing list
  4. PostgreSQL install problem
  5. Data on NAS / NFS
  6. create function error
  7. The leanest, meanest Windows installer possible
  8. Re: PostgreSQL, PGDAY, PGParty and OSCON 2007 Rocked!
  9. query to match '\N'
  10. How best to represent relationships in a database generically?
  11. ascii() for utf8
  12. Require entry of MD5 hash instead of plaintext password?
  13. How do I create a database if I can't connect to it?
  14. Re: Tunning PostgreSQL performance for views on Windows
  15. locale and performance?
  16. generating part of composite key
  17. tsearch2 problems in postgres?
  18. Question about Postgres
  19. NOTICE Acepted as Error After Upgrade
  20. The database slows down after a few weeks
  21. Re: Tunning PostgreSQL performance for views on Windows
  22. Postgresql over a SAN
  23. Re: granting acces to an external client
  24. Replicating db structure changes
  25. Porting MySQL data types to PostgreSQL
  26. C function problem with 8.2.4
  27. inherting triggers
  28. upgrade to 8.2.? or implement Slony, which first?
  29. running a script from a command line
  30. silent install of postgres for an embedded purposes
  31. More than one characters in DELIMITER (for COPY)
  32. Backslah in encrypt function.
  33. postgresql insert and dataset(c#)
  34. a few questions (and doubts) about xid
  35. Functions refering directly to table columns?
  36. ssl connections to postgresql
  37. GiST Support in 8.1
  38. Pattern matching with index
  39. Using result from current_database() into another command?
  40. Silent Uninstall of Postgres
  41. Reporting
  42. varchar does not work too well with IS NOT NULL partial indexes.
  43. Strange behaviour with Xfs filesystem and unix_socket_directory
  44. Connection error
  45. Slow query but can't see whats wrong
  46. PgAdmin GUI on the Linux Server
  47. about c# and postgresql
  48. Using COALESCE nside function
  49. Should SERIAL column have MAXVAL set on sequence
  50. Delete/update with limit
  51. regexp_replace
  52. =?windows-1257?Q?invalid_memory_alloc_request_size_214748364 8_using_toode?==?windows-1257?Q?_LIKE_'=E4%'?=
  53. Need help with bash script and postgresql
  54. Import to excel to postgres based website?
  55. Re: PGInstaller Project
  56. Debugging postgresql source on gdb
  57. posgres tunning
  58. spool function in nbtree index
  59. CentOS 4 RPMs for 8.2.4?
  60. Problem with large bytea fields in windows
  61. PGInstaller Project
  62. help with tsearch2 stem compile
  63. postgresql compile problem
  64. Difference between PRIMARY KEY index and UNIQUE-NOT NULL index
  65. shp2pgsql Help with sintax!
  66. Help with date math
  67. encodings
  68. Primary Key Performance with INTEGER vs. VARCHAR
  69. eBay Security Center
  70. Best interval timeout and check interval for Slony
  71. Char vs SmallInt
  72. Difference between PRIMARY KEY index and UNIQUE-NOT NULL index
  73. Re: Reminder: PostgreSQL PDXPGDay + PostgreSQL Party
  74. OSCON Booth volunteers
  75. psql-odbc configure error
  76. 8.2.4 signal 11 with large transaction
  77. Foreign key constraint question
  78. privillages for pg_class
  79. Retrieve the record ID
  80. Re: several postgres installations on the same machine?
  81. several postgres installations on the same machine?
  82. two phase commit
  83. "template1" being accessed by other users
  84. When is PostgreSQL 8.3 slated for release?
  85. memory leakage in libpg?
  86. Trying to tune postgres, how is this config?
  87. Unexpected crash
  88. Query performance strangeness..
  89. Database design : international postal address
  90. Ordering by a complex field
  91. tsearch2 on postgres8.2.4
  92. Can someone shed some light on following error: "pg_tblspc/16763/16764/PG_VERSION" is missing
  93. IN clause performance
  94. Will partial index creation use existing index?
  95. Feature request: Per database search_path
  96. Need help optimizing this query
  97. DBI/DBD::Pg and transactions
  98. monthly tally of new memberships
  99. Parrallel query execution for UNION ALL Queries
  100. Again about varchar()
  101. Can't SELECT from (INSERT ... RETURNING)
  102. REQUEST: option to auto-generate new sequences with CREATE TABLE(LIKE)
  103. it works, but is it legal to separate schema/table/field references using spaces
  104. redirecting output of pg_dump
  105. protect a database
  106. int8 vs int4
  107. yet another image: db or filesystem ? question
  108. Sylph-Searcher 1.0.0 released
  109. average/stddev on all values returned by a select distinct
  110. Update of table lags execution of statement by >1 minute?
  111. Altering a plan
  112. Re: ERROR: a column definition list is required for functions returning "record"
  113. interaction with postgres defined types in custom c functions
  114. PHP pg_connect
  115. Concurrency Question
  116. Issues with PL/PGSQL function..
  117. psql error while restoring database: unrecognized node type: 655
  118. Capturing return value of a function
  119. deferred check constraints
  120. What's the logical counterpart of the to_hex function?
  121. Moved postgres, now won't start
  122. Re: Postgres Geometry
  123. encrypting a query string
  124. unconvertable characters
  125. Weird error message in SQL function call
  126. SMTP
  127. createing indexes on large tables and int8
  128. Weird error message in SQL function call
  129. How to make it work? (PL/Perl + Net::LDAP)
  130. pg_dump without blobs
  131. Could not create log file error?
  132. count the number of bits set to 1 in a bit string field
  133. slony over LAN and VPN
  134. Joining with set returning functions
  135. authorizations for a statement
  136. smtp
  137. How to Cluster an Index live?
  138. PostgreSQL equivelant of this MySQL query
  139. pg_dump vs schemas
  140. restore dump to 8.19
  141. multirow insert
  142. how to measure performance slony
  143. order is preserved by outer select?
  144. question on scan of clustered index
  145. doubt
  146. returns setof rec... simple exampe doesn't work
  147. Problems of connexion with Tsearch2 functions
  148. TOAST, large objects, and ACIDity
  149. how to resolve invalid primary checkpoint
  150. Updates/Changes to a database
  151. Big table with UNION ALL or partitioning with Tsearch2
  152. Big table with UNION ALL or partitioning with Tsearch2
  153. Panic error on attempted update
  154. libpq: Specify pass phrase for SSL key
  155. Database corruption: finding the bad block
  156. Limit number connections by IP
  157. Mac OS X
  158. deleting rows with foreign keys
  159. Re: Count(*) throws error
  160. Count(*) throws error
  161. Re: exit code -1073741819
  162. optimizing postgres
  163. =?us-ascii?Q?auditing=20question?=
  164. how does a temp table work?
  165. troubble with contrib compile
  166. Strange round behaviour w/ more than 2 decimals
  167. How to pg_dumpall without root password
  168. Re: exit code -1073741819
  169. Re: exit code -1073741819
  170. Re: exit code -1073741819
  171. Re: exit code -1073741819
  172. exit code -1073741819
  173. Am I missing something about the output of pg_stop_backup()?
  174. Implementing 2 different transactions in a PL/Perl function
  175. Function to ADD a value into each column of real[]
  176. Adjacency Lists vs Nested Sets
  177. Limit connections per username
  178. Problems with linkage
  179. Vaccum Stalling
  180. TOAST, large objects and ACIDity
  181. vacuumdb: PANIC: corrupted item pointer
  182. Re : Postgres 8.2 binary for ubuntu 6.10?
  183. pgpass.conf
  184. How to join materalized view to child tables
  185. Duplicate Unique Key constraint error
  186. Fastest way to join materalized view to child tables
  187. Postgres 8.2 binary for ubuntu 6.10?
  188. Re: xpath_* namespace bug
  189. Accent-insensitive search
  190. One Large Table or Multiple DBs?
  191. pam_pgsql question
  192. Strange Problem
  193. catalog location
  194. Hyper-Trading
  195. Implementation of three new operators inside the PostgreSQL
  196. What secret resipy of PostgreSQL (insert more faster than delete)?
  197. How to get fast ~ operator using C locale
  198. User-Defined Types
  199. Vacuum issue
  200. Restoring the DB from others user DB Backup.
  201. dropdb ; createdb equivalent without createdb permission?
  202. Windows Vista not working
  203. pam_pgsql question
  204. xpath_* namespace bug
  205. Performance Question - Table Row Size
  206. russian case-insensitive regexp search not working
  207. Re : Design Tool
  208. How to obtain a sequence's increment value from the system catalog
  209. Force SSL / username combination
  210. Database Insertion commitment
  211. Direct I/O
  212. The speed problem of Varchar vs. Char
  213. Encoding questions
  214. feature requests
  215. Changing DB Encodings
  216. Crash in PostgreSQL-8.2.4 while executing query
  217. catalog location
  218. Arrays of records?
  219. PostGreSQL Replication
  220. Unable to get postgres running after long time no vacuum
  221. Unable to get postgres running after long time no vacuum
  222. ssl enabling of postgres on Mac OS X
  223. Re: autovacumm not working ?
  224. Update a single row without firing its triggers?
  225. Capturing return value of a function in Pl/Perl
  226. ISO TESTS for a Pg lexer+parser
  227. Implementation of three new operators inside the PostgreSQL
  228. CASE in ORDER BY clause
  229. REVOKE "ALL FROM ALL"
  230. Check if language is installed
  231. DB crashed and duplicated template0 db
  232. Day of week vs. Language
  233. Polymorphic delete help needed
  234. Localization trouble
  235. Working with dates
  236. Nested Transactions in PL/pgSQL
  237. simple query question to use with DBI selectall_hashref
  238. Way to determine index bloat stats?
  239. Re: Design Tool
  240. Re: [general] [general] perpetual dump/restore problem
  241. Re: [general] perpetual dump/restore problem
  242. Vacuum issue
  243. How to get fast ~ operator using C locale
  244. Large Project, Integration with existing Oracle and MS SQL
  245. perpetual dump/restore problem
  246. Problem with autovacuum and pg_autovacuum
  247. Re: [general] growing disk usage problem: alternative solution?
  248. blobs
  249. tsearch2 in multilingual database?
  250. tsearch2 questions