View Full Version : Pgsql General



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