PDA

View Full Version : Pgsql General

  1. Postgresql string parsing
  2. Getting more information about errorcodes such as when these error1happen
  3. PostgreSQL x Sybase
  4. using types for encrypting fields
  5. Connecting
  6. Create an index with a sort condition
  7. postgresql.conf listen_addresses causing connection problems
  8. about un-discrible
  9. updategram in pg
  10. using types for encrypting fields
  11. undiscrible
  12. Implementation Suggestions
  13. Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server
  14. PostgreSQL client api
  15. Auto convert for type?
  16. best practice in upgrading db structure
  17. AD:tenten
  18. Re: FAQ 1.1
  19. More AIX 5.3 fun - out of memory ?
  20. deleting function from pg_catalog.pg_proc
  21. Concurrency question
  22. 32 bit applications against 64 bit postgres server
  23. table owner of cloned databases
  24. Schema's versus tablespace
  25. checking data type
  26. Data model question regarding usage of arrays.
  27. FAQ 1.1
  28. Re: Creating serial ID on Windows.
  29. Issues with restoring
  30. getting deadlocks on full table lock
  31. donations
  32. Recovery in PostgreSql
  33. General advice on database/web applications
  34. frustrated by plpgsql procedure
  35. ALTER COLUMN from date to timestamp without time zone
  36. How can I known the size of a database, table by table ?
  37. ACL question
  38. PostgreSQL's XML support comparison against other RDBMSes
  39. Converting a database from LATIN1 to UTF-8
  40. Inheritance
  41. What to index to speed up my UNION views?
  42. Error backing up database (Unicode)
  43. case insensitive match in unicode
  44. MIB for PostGReSQL
  45. Re: Suse Linux 10.0
  46. ambulkdelete
  47. pg 8.1.2 performance issue
  48. A place to post pgbench results
  49. Planet PostgreSQL : Do you want to blog?
  50. experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMDand Intel CPUs as far as Postgresql is concerned
  51. Re: regarding join
  52. Query plans for plpgsql triggers
  53. Problems running regression tests
  54. Re: Between !
  55. Between !
  56. Visual Fox Pro clients using MySQL or PostgreSQL back-end wanted for bookfeedback
  57. UPDATE
  58. inheridt tables from db
  59. When does a check constraint execute?
  60. How Using new created DB
  61. Re: COPY command documentation
  62. libpq vs pqxx
  63. basic stored proc/transaction question
  64. Hibernate Query Question - Get most recent unique rows
  65. pgadmin
  66. PostgreSQL support on Redhat Advance Server 2.1
  67. ADO.NET ExecuteReader returns no rows
  68. URGENT! could not access status of transaction
  69. another seemingly simple encoding question
  70. Practical limit on number of tables ina single database
  71. Retrieve large object
  72. Re: COPY command documentation
  73. where to find pg_config....
  74. Parallel sequential scans
  75. PostgreSQL 8.1 v. Oracle 10g xe
  76. Build only clients
  77. Re: version problem with pg_dump
  78. Re: version problem with pg_dump
  79. Re: version problem with pg_dump
  80. prepared SELECT and placeholders with NULL values
  81. Re: version problem with pg_dump
  82. Re: version problem with pg_dump
  83. Re: Hi,
  84. SELECT beer FROM pub WHERE location = 'Europe'
  85. Interval regression test failing with -march=pentium4
  86. COPY command documentation
  87. ERROR: could not convert UTF8 character to ISO8859-1
  88. Logging of sql statements?
  89. Some pgbench results
  90. Re: partial resultset in java
  91. Re: back slash separated values
  92. Re: partial resultset in java
  93. substitute for array functions in postgresql v7.3 ?
  94. Re: question about the admin contrib module and binary
  95. Hi,
  96. Re: question about the admin contrib module and binary
  97. Re: question about the admin contrib module and binary
  98. Re: Advantages of PostgreSQL over MySQL 5.0
  99. quirk with update a from b
  100. Sounds silly ...
  101. Updating database structure
  102. how to update structural & data changes between PostgreSQL databases?
  103. question about the admin contrib module and binary RPMs
  104. Old pg_xlog files
  105. Re: index for inet and >> (contains) function
  106. Re: Autovacuum Daemon Disrupting dropdb?
  107. java_reset - how it works
  108. Re: db sever seems to be dropping connections
  109. Re: db sever seems to be dropping connections
  110. ANNOUNCE: Type-safe interface to PostgreSQL
  111. index for inet and >> (contains) function
  112. about "explain analyze" cannot get detailed analyzed results forqueries in a plpgsql function
  113. Updating a primary key
  114. Advantages of PostgreSQL over MySQL 5.0
  115. pg 8.1.3 on AIX
  116. back slash separated values
  117. Enforcing serial uniqueness?
  118. Re: How to release locks
  119. Confused about a function returning SETOF
  120. partial resultset in java
  121. Postgresql won't run after upgrade to fc5
  122. index scan backward plan question
  123. Re: Postgresql won't run after upgrade to fc5
  124. W3C XML Schema -> PostgreSQL?
  125. Troubling On-line Backup LOG messages
  126. Connection error
  127. invalid page header
  128. Actual age() of cleanly vacuumed db
  129. Re: passing parameters to a trigger function (solved)
  130. passing parameters to a trigger function
  131. xml output
  132. "libpq.lib"
  133. Using postgresql in a HA/load balancing environment?
  134. Using postgresql in a HA/load balancing environment?
  135. Order of Update - Second Try
  136. xml output.
  137. Long running transactions
  138. Re: Difference between "add column" and "add column" with default
  139. question about pg_hba.conf
  140. How I can get the real data type result instead of integer data type?
  141. Re: Licensing of .DLL files
  142. Re: db sever seems to be dropping connections
  143. Licensing of .DLL files
  144. Double checking my logic?
  145. Updating in multiple tables
  146. Re: Difference between "add column" and "add column" with default
  147. vacuum full taking much longer than dump + restore?
  148. Re: ambuild parameters
  149. Connecting
  150. How to idenity duplicate rows
  151. ambuild parameters
  152. "\set AUTOCOMMIT off" has affect
  153. PANIC: heap_update_redo: no block
  154. =?iso-8859-1?Q?RE=3A_Postgresql_over_ppc4_=B0?=
  155. db sever seems to be dropping connections
  156. =?iso-8859-1?Q?Postgresql_over_ppc4_=B0?=
  157. pg_dump cross-version support
  158. ' and \ characters in passwords
  159. OpenSuse10.0 and postgresql
  160. Order of Update
  161. Transactions
  162. Re: Grant Priviliges on column
  163. Inherit for parallel log tables
  164. Server "deadlock"?
  165. Strange startup error
  166. pgsql variables from records
  167. efficiency of group by 1 order by 1
  168. Grant Priviliges on column
  169. Table Rows Not Properly Added
  170. Encountering NULLS in plpgsql
  171. can't create user collumn
  172. Query
  173. each line counter
  174. pgsql variables from records
  175. after insert trigger hangs
  176. Transferring databases to another Server
  177. Slow trigger on identical DB but different machine
  178. pregunta de principiante
  179. About index for temporay table in a plpgsql function
  180. Re: PostgreSQL Knowledge Base
  181. pg_dumpall: permission denied for relation pg_shadow
  182. Re: picking the correct locale when doing initdb
  183. Re: Error I don't understand, losing synch with server
  184. Disabling persistent connections?
  185. Re: will slony work for this ?
  186. Constraint Question
  187. SSL or other libraries for Windows-to-Linux PostgreSQL connection?
  188. Error I don't understand, losing synch with server
  189. Replication & web apps
  190. PostgreSQL scalability concerns
  191. Only 6 days left to get PGLA for 5 dollars (promtion has been adjustedto 100 units)
  192. Re: PostgreSQL Knowledge Base
  193. Pb d'installation de postgreSQL 8.1.3-1 win32
  194. Re: PostgreSQL on Windows not starting
  195. Re: What's a good default encoding?
  196. Re: Indexes on array columns
  197. How do I make a timestamp column default to current time
  198. Reprise of Oracle decode functionality...now with nifty plperlu (andtwo cupholders)
  199. apparent loss of sys tables!! - help
  200. Re: URGENT!!! SELECT statement please help
  201. hi problem with installing postgresql8.1
  202. PostgreSQL on Windows not starting
  203. \copy combine with SELECT
  204. Case Sensitive problem
  205. Re: Case Sensitive problem
  206. Re: Case Sensitive problem
  207. Concurrencia
  208. Disability the trigger
  209. Problems with Postgres and TCP/IP Protocol
  210. ERROR: FULL JOIN is only supported with merge-joinable join conditions
  211. Remote Sync
  212. PostgreSQL Knowledge Base
  213. psqlODBC Unicode 8.01.02.00 Driver "Overflows" On MS-Access Dates
  214. encoding aliases
  215. Five reasons why you should never use PostgreSQL -- ever
  216. tsearch is slow
  217. full text indexing
  218. Inserting é in psql - invalid byte sequence for encoding "UNICODE": 0xe9
  219. Re: out of memory
  220. Dumping rows into an array?
  221. out of memory using Postgres with Spring/Hibernate/Java
  222. Error in Postgresql after a Machine Crash
  223. Re: pgsql and streams
  224. pgsql and streams
  225. Re: question about postgresql time intervals
  226. Re: Build failures on RedHat 3.0 with openssl/kerberos
  227. audit system for parent-child tables
  228. Turn OFF Stats of Postgresql
  229. What's a good default encoding?
  230. SQL job in the wireless industry
  231. open file counts in 8.1.2?
  232. Resetting priveleges on a table
  233. Clustered PostgreSQL
  234. stored procedure
  235. Utility of GRANT EXECUTE
  236. Re: Update value to "the first character is capital and
  237. Urgent !!! Please Help Me
  238. Dynamic function execution?
  239. Possible data corruption with Postgres 7.4.8
  240. â in text field
  241. Relation 'pg_largeobject' does not exist
  242. catch SELECT statement return
  243. Hour records within a date range
  244. Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
  245. ExtenDB
  246. dump from old version
  247. Transaction eating up all RAM
  248. Wal -long transaction
  249. Tsearch2 ranking
  250. Problem getting plpgsql to choose the right query plan