View Full Version : Pgsql General



  1. ERROR: FULL JOIN is only supported with merge-joinable join conditions
  2. FATAL: terminating connection due to administrator command
  3. Possible infinite loop in query using bitmap scans
  4. Project survey: Commercial Companies and the Open Source Community
  5. URGENT!!! SELECT statement please help
  6. Create a new table
  7. Re: COPY has no access permissions
  8. Java Studio Creator
  9. COPY has no access permissions
  10. getting failed while creating user accounts
  11. Re: getting failed while creating user accounts
  12. Autovacuum Daemon Disrupting dropdb?
  13. Re: Autovacuum Daemon Disrupting dropdb?
  14. Any Delphi programmers on this list?
  15. Table locks and serializable transactions.
  16. hi problem with installing postgresql8.1
  17. Re: in Pl/PgSQL, do commit every 5000 records
  18. Re: NULL TIMESTAM problem
  19. Re: Creating a function that acept any data type
  20. Re: Creating a function that acept any data type
  21. Schema is Missing
  22. Can the PostgreSQL store the Multimedia files
  23. programatic database dump
  24. About updates
  25. Re: panic during pgsql startup
  26. in Pl/PgSQL, do commit every 5000 records
  27. Baffled by failure to use index when WHERE uses a function
  28. Re: PL/pgSQL question
  29. questions?
  30. Re: select where in and order
  31. select where in and order
  32. Re: Run PostgreSQL with Administrator account in Windows
  33. PostgresSQL 8.13 builds perfect on new Mac OS X 10.4 for Intel Chips
  34. posgresql server connection
  35. PL/pgSQL question
  36. Storage Estimates
  37. JDBC
  38. NULL TIMESTAM problem
  39. multi-column aggregates
  40. ExtenDB
  41. view creation question
  42. Re: double-quoted field names in pgadmin
  43. (sem assunto)
  44. double-quoted field names in pgadmin
  45. Re: Triggers and Multiple Schemas.
  46. questions?
  47. null timestamp
  48. Re: database/schema level triggers?
  49. Re: Triggers and Multiple Schemas.
  50. Re: column type varchar(128) not null default '' vs varchar(128)
  51. column type varchar(128) not null default '' vsvarchar(128)
  52. Triggers and Multiple Schemas.
  53. Tsearch2 cache lookup problem
  54. 8.0 Client can't connect to 7.3 server?
  55. Re: distance calculation usng lat and long in miles
  56. Re: distance calculation usng lat and long in miles
  57. Re: distance calculation usng lat and long in miles
  58. Problem with Transaction
  59. Re: Errors ignored on restore
  60. Re: Errors ignored on restore
  61. Out of memory error on pg_restore
  62. About array in PlPgsql trigger function
  63. plperl %_SHARED and rollbacks
  64. database/schema level triggers?
  65. regarding contains operator
  66. reindexdb script required in 8.1?
  67. ALTER TABLE -- how to add ON DELETE CASCADE?
  68. Perspective: PostgreSQL usage boon after release of 8.2
  69. User defined EXCEPTIONs
  70. how to setup default privileges
  71. Re: Question about index usage
  72. per-statement, after, what's new?
  73. Re: Logging seq scans
  74. real - integer type cast in prepared statements
  75. Re: Benchmark-Comparison PostGreSQL vs. SQL Server
  76. Re: Logging seq scans
  77. Re: Question about index usage
  78. pg_dump error - filesystem full
  79. JSP pages don't work with database after postgres downgrade
  80. Is the "ACCESS EXCLUSIVE" lock for TRUNCATE really necessary?
  81. Sequencial scan instead of using index issue again
  82. is it possible to get current_user inside security definer function ?
  83. Re: [pgsql-general] Daily digest v1.5986 (24 messages)
  84. CRLF problem going from Linux PostgreSQL server to WinXP clientvia ODBC.
  85. pg-admin
  86. About when we should setup index?
  87. ERROR: xlog flush request not satisfied
  88. Re: [OFFTOPIC] Typo3 + Postgresql anyone?
  89. Syntax error, but where?
  90. Re:
  91. understanding post gres indexes
  92. PostgreSQL on Intel Core Duo Macs?
  93. Re: Insert fails when it shouldn't
  94. tsearch2 match substrings in words
  95. What query on system tables retrieves table or queries definitoin
  96. Re: ERROR: column "datpath" does not exist
  97. Using same database from XP and Linux in notebook
  98. Questions about privileges
  99. Re: problem with windows xp sp2 and postgres-8.1.3
  100. Re: pgbench
  101. Accessing composite type columns in indexes
  102. How to determine the table a query or a views columns come from?
  103. installing xml2 for pg 8.1 on winxp
  104. Updates to my PostgreSQL Wiki
  105. User tables
  106. record OID to table
  107. Re: ERROR: column "datpath" does not exist
  108. Problem with function that returns a cursor
  109. SELECT Question
  110. tsearch2 match substrings
  111. Quick psqlODBC driver setting
  112. A pg_hba.conf problem - again...
  113. PgsqlODBC connection parameters in the registry
  114. Physical column size
  115. Postgres automatically inserts chr(13) whenever chr(10) is inserted
  116. extended index info
  117. xml and utf-8
  118. ERROR: column "datpath" does not exist
  119. Problem with Function
  120. [Fwd: Schema Question]
  121. Linux cluster application
  122. Exception: An I/O error occured while sending to the backend
  123. Re: Need a GNU SQL CLI tool for Win32 with ODBC support.
  124. query timeout
  125. Re: query timeout
  126. Solaris 10 ZFS Postgresql request for comments
  127. How to save and restore a template database ?
  128. Question about the contrib rpm ?
  129. Question about "pg_upgrade"
  130. Insert fails when it shouldn't
  131. Installing PosygreSQL 8.1 on Windows2003 server in terminal session(remote desktop)
  132. Postgres does not accept socket connections
  133. Default Access Exclusive Lock on Update?
  134. Thread scheduling in postgresql 8.1.3 on windows
  135. php postgresql
  136. Temporary data storage in PL/PGSQL functions
  137. SET TRANSACTION on pl/pgSQL function
  138. Need a GNU SQL CLI tool for Win32 with ODBC support.
  139. Re: [OFFTOPIC] Typo3 + Postgresql anyone?
  140. Going crazy comparing bytea columns
  141. Re: Special offer with a possible dontation to the project
  142. SELinux strangeness with 8.1.2 and 8.1.3
  143. a web framework for postgresql?
  144. Re: Looking for a fix to index bloat
  145. Triggers question
  146. Re: regarding grant option
  147. Data corruption zero a file - help!!
  148. Questions about large objects and the WAL
  149. Looking for a fix to index bloat
  150. Full Text Indexing and Syntax
  151. Re: problem with windows xp sp2 and postgres-8.1.3
  152. PQisBusy returns true but no more data is received.
  153. Re: How many postmasters should be running?
  154. Problem with PostgreSQL 8.1.3 on Windows XP Pro
  155. implicit tables syntax disappeared from 8.0->8.1
  156. indexes
  157. Re: Temporal Databases, offtopic - relative updates
  158. Size comparison between a Composite type and an equivalent Text field
  159. Re: rotate records
  160. Re: rotate records
  161. How many postmasters should be running?
  162. Dumping functions
  163. In case nobody has seen this survey from Sun ...
  164. audit tables adding columns
  165. Breaking Path/Polygon Data into Pieces
  166. Re: Operator for int8 array
  167. Which indexes does a query use?
  168. Re: Management of Concurrent Clients
  169. Re: Postgre capability
  170. majordomo unmaintained, postmaster emails ignored?
  171. Management of Concurrent Clients
  172. Re: psql client binary
  173. Re: psql client binary
  174. Re: psql client binary
  175. Stored procedure doesn't return expected result.
  176. Postgre capability
  177. psql client binary
  178. Re: Postgres Win32 libpq Samples
  179. Wish: remove ancient constructs from Postgres
  180. postgresql documentation
  181. From ASCII to UTF-8
  182. Postgres Win32 libpq Samples
  183. createuser permssion for group
  184. non-btree primary key
  185. rotate records
  186. Re: Error correction to FAQ
  187. Another perplexity with PG rules
  188. "...unknown user name or bad password" error during install
  189. How to tell how much of the database is being used for data.
  190. Wrong length of bytea field
  191. Requesting LinuxWorld East staffers
  192. phantom backends
  193. Backup file extension
  194. collation & UTF-8
  195. Lista de correo
  196. checksum error from windows to linux
  197. How do I prevent binding to TCP/IP port outside of localhost?
  198. User groups
  199. psql is very slow
  200. Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?
  201. Re: checksum error from windows to linux
  202. Re: psql is very slow
  203. Re: How do I prevent binding to TCP/IP port outside of localhost?
  204. Operator for int8 array
  205. How to read odbc and pgadmin lists from news server
  206. How to load 6 MB file to database
  207. Re: Temporal Databases
  208. Re: Temporal Databases
  209. Re: subtracting minutes from date
  210. How I changed the encoding of template1 after the fact
  211. subtracting minutes from date
  212. Is the pg_locks been used?
  213. pg_autovacuum on Windows triggers string warning
  214. Re: Limitations : Number of ...
  215. Re: Temporal Databases
  216. Limitations : Number of ...
  217. pg_dump warning with -Fc option
  218. Cannot load number rows
  219. Re: Cannot load number rows
  220. SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc
  221. upgrade PostgreSQL 8.x on production FreeBSD
  222. ExclusiveLock without a relation in pg_locks
  223. Is there a way to check which indexes are being used for a table
  224. Disable FK constarints
  225. actual SQL statement
  226. DBD::Pg 1.44 released
  227. now() time off
  228. Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntaxerror at or near "RELEASE"
  229. ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE"
  230. =?ISO-8859-1?Q?R=E9f=2E_=3A_Re=3A__Out_of_memory_using_ora2pg ?=
  231. PG 8 stop working !?
  232. Re: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR:
  233. Re: Attn. PostgreSQL.org webmasters: Site Link not working
  234. Re: Attn. PostgreSQL.org webmasters: Site Link not working
  235. setting LC_NUMERIC
  236. =?ISO-8859-1?Q?R=E9f=2E_=3A_Re=3A__Out_of_memory_using_ora2pg ?=
  237. =?ISO-8859-1?Q?R=E9f=2E_=3A_Re=3A__Out_of_memory_using_ora2pg ?=
  238. Out of memory using ora2pg
  239. Re: TSearch2 from HEAD UTF8 German Compunds.
  240. Postgresql Replication
  241. Question about COPY to/from
  242. Performance Problems
  243. Bus error on make check
  244. How to specify infinity for intervals ?
  245. How to determine number of established connections
  246. What is the syntax for setting a default date in PostgreSQL
  247. Re: What is the syntax for setting a default date in PostgreSQL
  248. Postgresql win32 vs MySql win32
  249. What is the syntax for setting a default date in PostgreSQL?
  250. Encodings