PDA

View Full Version : Pgsql General

  1. find out data types using sql or php
  2. WAL archiving idle database
  3. cases in rules problem
  4. Re: subversion support?
  5. How to ALTER a TABLE to change the primary key?
  6. Query_time SQL as a function w/o creating a new type
  7. TRUNCATE - timing of the return of disk space - caused by long-lived client?
  8. INDEX and JOINs
  9. Selecting tree data
  10. Re: subversion support?
  11. Re: subversion support?
  12. Re: subversion support?
  13. Re: subversion support?
  14. Re: subversion support?
  15. 2 versions running & using pg_dumpall
  16. Re: Delete/Update with ORDER BY
  17. Re: subversion support?
  18. Re: subversion support?
  19. Delete/Update with ORDER BY
  20. execute pg_dump via python
  21. select count() out of memory
  22. [PGSQL v8.2.5] Similar queries behave differently
  23. postgres bash prompt error while user creation
  24. Solaris binaries for pgAdmin III
  25. subversion support?
  26. Re: FATAL: could not reattach to shared memory
  27. GRANT error
  28. Migration questions for upcoming 8.3 release and fts
  29. PostgreSQL and AutoCad
  30. Fragments in tsearch2 headline
  31. Re: subversion support?
  32. jdbc: ERROR transaction is read-only
  33. google
  34. initdb: file "/usr/local/share/postgresql/snowball_create.sql" doesnot exist
  35. using libpq.lib in Microsoft C++ (managed)
  36. "Concatenate" two queries - how?
  37. Constraints involving a system table
  38. Automating Backup & Restore
  39. 8.3b1 in production?
  40. deadlock detected, only selects (not select-for-update)
  41. Re : pg_dump auto login
  42. Selecting K random rows - efficiently!
  43. Install plJava
  44. (Never?) Kill Postmaster?
  45. Start DB giving fatal message.(linux)
  46. function result cache for pl/pgsql
  47. Using Postgres as a "embedded" / SQL Lite database on Windows
  48. Extracting Index Creation Script
  49. Service pgsql-8.1 failed to start
  50. newbie: update timestamp trigger?
  51. Your account has been flagged !
  52. data statistic functions
  53. can't compile Pl/Java
  54. Reliability of WAL replication
  55. Determine query run-time from pg_* tables
  56. pg_dump auto login
  57. alter database tablespace
  58. How to transfer from place to plase without backup/restore
  59. Postgres SQL Client for Suse Linux
  60. print command in sproc
  61. How to transfer from place to plase without backup/restore
  62. Investigating memory leak of trigger library using valgrind
  63. How install postgreSQL in another drive than C:?
  64. Problem with BYTEA, CAST, and pg_dump
  65. unicode searches failing that use % and LIKE operators
  66. Bitmap Heap scan 8.1/8.2
  67. small query for indexed tables runs long time
  68. How to use 'toast'
  69. command to view the tables
  70. Select Command
  71. Indexes & Primary Keys (based on the same columns)
  72. SQL spec/implementation question: UPDATE
  73. Explicit Named Indexes for Constraints
  74. Photos from the PostgreSQL Conference Fall 2007
  75. Fragments in tsearch2 headline
  76. looking for some real world performance numbers
  77. UNIQUE INDEX and PRIMARY KEY
  78. Perhaps silly question about empty search_path
  79. Inheritance foreign key unexpected behaviour
  80. keeping an index in memory
  81. Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
  82. Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
  83. Questions about LIMIT/OFFSET
  84. install failed with "not NTFS filesystem"
  85. uniquely indexing Celko's nested set model
  86. Question regarding Hibernate ORDER BY issue
  87. ERROR: Could not access status of transaction ####
  88. Re : Re : Re : Resetting SEQUENCEs
  89. Generating sql to capture fully qualified table names???
  90. Temp Table
  91. Order-independent multi-field uniqueness constraint?
  92. Fatloss computer program
  93. HP Desktop for sale!
  94. update with select can handle concurrency problems ?
  95. update with select can handle concurency problems ?
  96. Stalled post to pgsql-bugs
  97. Fetch
  98. Re : Re : pg_dump SERIAL and SEQUENCE
  99. Re : Re : Resetting SEQUENCEs
  100. Re : Abbreviation list
  101. Did pg_dumpall and imported, NEED TO START OVER
  102. pg_dumpall's subseq IMPORT ERRORS
  103. PG/Tcl and Expect?
  104. relations does not exist
  105. Abbreviation list
  106. autovacuum and locks
  107. Resetting SEQUENCEs
  108. Re : Resetting SEQUENCEs
  109. Re : Am I overseen ?
  110. Re : pg_dump SERIAL and SEQUENCE
  111. pg_dump SERIAL and SEQUENCE
  112. Re: Am I overseen ?
  113. Re : pg_dump - schema diff compatibility
  114. Am I overseen ?
  115. ordering rows
  116. running postgres
  117. Problem of installation on Mac
  118. a failover scenario
  119. Crosstab Problems
  120. (NONE)
  121. Suggestions for Remote Procedure Calls from PG, please?
  122. downloading and installing postgreSQL
  123. conditional alter table add ?
  124. Prepared statement parameters for an 'IN ()' clause
  125. Array intersection
  126. CVS Commands
  127. Possibilities of Fine Grained Access Control?
  128. newbie question
  129. DROP VIEW lasts forever
  130. Re: atomic commit;begin for long running transactions , in combination with savepoint.
  131. dblink and hostname resolution problem
  132. CVS and Eclipse
  133. Poor Plan selected w/ not provided a date/time but selectingdate/time from a table
  134. Determining oldest WAL for Archiving PITR Standby
  135. Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
  136. Index Usage
  137. SPI_exec() + PG_TRY/PG_CATCH
  138. How to set config param temporarily?
  139. Logging deadlocked statements?
  140. need help with rebuilding postgresql
  141. insert continue on error
  142. Vista Home Premium Installation troubles...
  143. How to view the SQL that Pg actually executes?
  144. Preserving view source code
  145. move databases files location
  146. Updating a production database schema from dev server
  147. variable in COPY <table> TO variable
  148. RSA PKCS #1 v2.1 functions for PostgreSQL
  149. PostgreSQL as a backend for Wizcon 9.2
  150. Re: Architecture diagram!
  151. Re: Convert bytea to Float8
  152. Group By question
  153. improvement proposition
  154. Architecture diagram!
  155. Create artificial key without temp sequence
  156. pgadmin's pgagent job scheduler
  157. problem with a column of type timestamp
  158. Inconsistence in transaction isolation docs
  159. 8.3 beta problems
  160. Re: Convert bytea to Float8
  161. Re: Convert bytea to Float8
  162. Re: Convert bytea to Float8
  163. Problems inserting data into a table with a sequence
  164. 8.2.3: Server crashes on Windows using Eclipse/Junit
  165. 8.2.5 -> 8.3 beta tsearch2 help
  166. TSearch chain dictionaries
  167. Re: atomic commit;begin for long running transactions , in combination with savepoint.
  168. Re: atomic commit;begin for long running transactions , in combination with savepoint.
  169. Convert bytea to Float8
  170. Re : pg_dump - schema diff compatibility
  171. Re: atomic commit;begin for long running transactions , in combination with savepoint.
  172. Re : Very asynchrnous replication system
  173. Using case expressions in update set clause
  174. Will UPDATE lock if FROM refers to target table?
  175. What encoding to use for English, French, Spanish
  176. Re: atomic commit;begin for long running transactions , in combination with savepoint.
  177. fmgr_info_cxt_security() modifies variable?
  178. db errors
  179. replicating to a stopped server
  180. PLPGSQL 'SET SESSION ROLE' problems ..
  181. Aggregate View and Conditions taking FOREVER
  182. Using C API
  183. Recommended method for creating file of zeros?
  184. INSERT RETURNING
  185. atomic commit;begin for long running transactions , incombination with savepoint.
  186. CHAR SETS
  187. contrib / fuzzystr documentation
  188. convert binary string to datum
  189. can I define own variables?
  190. [OT] xkcd - A webcomic of romance, sarcasm, math, and language
  191. Guideline on use of temporary tables
  192. replicating to a stopped server
  193. Need advice on keeping backup database up to date
  194. Detailed logging, but only for one user?
  195. max_*, shared_buffers, and shared memory
  196. Missing files under pg_data following power failure
  197. DB errors
  198. Re: Out of memory with ODBC
  199. different date-time in base and in system
  200. Query problem
  201. pg_dump - schema diff compatibility
  202. extracting multiple results from a set of tuples
  203. how to truncate/purge the pg_xlog directory?
  204. not work in IE
  205. Declare Cursor
  206. Postgres 8.2.5 compilation problem on OpenSolaris/Solaris
  207. Feature request: SSL Client Cert Authentication
  208. Support for distributed transactions in 8.2.5
  209. Invalid error message when user has nologin attibute
  210. Calculation of per Capita on-the-fly - problems with SQL syntax
  211. XMIN semantic at peril ?
  212. Not able to insert binary Data having NULL
  213. PLPGSQL 'SET SESSION ROLE' problems ..
  214. silent install
  215. 8.2.4 selects make applications wait indefinitely
  216. This Watch is wondrous
  217. Default Ubuntu post-install Qs (PG v7.4)
  218. Coercing compound types to use generic ROW comparison operators
  219. drop table cascade doesn't drop manual sequences
  220. preferred way to use PG_GETARG_BYTEA_P in SPI
  221. <> ALL( ... ) and <> ANY ( ... ) didn't behave as expected
  222. Disable triggers per transaction 8.2.3
  223. ORDER BY - problem with NULL values
  224. corrupt database?
  225. Upper and Lower-cased Database names?
  226. pgodbc + Excel + msquery + background refresh
  227. Re: about Command Prompt
  228. replacing single quotes
  229. SLEEP in posgresql
  230. How to speedup intarray aggregate function?
  231. Solutions for listening on multiple ports?
  232. disjoint union types
  233. move whole schema to a new tablespace
  234. about Command Prompt.
  235. Re: "timer" script from SAMS book or equivalent?
  236. slow request
  237. foreign keys and memory consumption
  238. DB upgrade
  239. Multiple versions on same box
  240. PG_TRY(), PG_CATCH()....
  241. speeding up CUBE queries
  242. Lifting WHERE conditions out of inner select
  243. How to make LIKE to use index in "abc%" query?
  244. SPI dumping core on large palloc
  245. Re: Database reverse engineering
  246. Problem with SELECT
  247. Install dblink on postgres server on windows
  248. starting a stored procedure+rule AFTER an insert
  249. Re : Very asynchrnous replication system
  250. German soundex