PDA

View Full Version : Pgsql General

  1. Angle Between Lines
  2. Re: Installing debugger
  3. Re: psql proxy
  4. Re: recommended way of separating data from indexes
  5. Re: Howto return values from a function
  6. Setting up phppgadmin under https/ssl (Apache)
  7. Re: triggers: dynamic references to fields in NEW and OLD?
  8. =?iso-2022-jp?B?GyRCOkZFWSEiNTkkNyQvJCo0aiQkJDckXiQ5ISMbKEI=? =
  9. SSL auth problem
  10. PostgreSQL executing my function too many times during query
  11. sp: error message not coherent with actual code
  12. Re: Question on warm standby log shipping
  13. DB Locks
  14. Re: Password safe web application with postgre*s*
  15. problem with serial data type and access
  16. Re: Howto return values from a function
  17. Re: help
  18. Re: Need for help!
  19. Re: Non completing Vacuumdb
  20. calculating extent on basis of distance from a given point
  21. Password safe web application with postgre
  22. help
  23. Re: postgres crash when select a record
  24. Populating a sparse array piecemeal in plpgsql
  25. DB page cache/query performance
  26. Need timestamp function that will change within a transaction
  27. Surprising syntax error
  28. Re: postgres crash when select a record
  29. Re: postgres crash when select a record
  30. Re: postgres crash when select a record
  31. postgres crash when select a record
  32. Re: Strange behaviour - performance decreases after eachTRUNCATE
  33. how to return parts of records from a function
  34. ranked subqueries vs distinct question
  35. Underscore "_" in LIKE pattern
  36. Re: Underscore "_" in LIKE pattern
  37. Couple of question on functions
  38. WKT Viewer
  39. Alias in the HAVING clause
  40. Totally unremovable dead rows?
  41. C function
  42. Re: how can i get initdb
  43. too many warnings
  44. Conditional on Select List
  45. Affected # of Rows After TRIGGER/RULE Return
  46. PG -v- MySQL
  47. Re: Substring Problem
  48. Strange behaviour - performance decreases after each TRUNCATE
  49. DB Connections in TIME_WAIT state
  50. Substring Problem
  51. Re: Stripping out slony after / before / during pg_restore?
  52. Stripping out slony after / before / during pg_restore?
  53. Upgreade 8.3.0 to 8.3.1 on windows: insufficient privileges to install system service
  54. Problem with transaction isolation level
  55. Compiling trigger function with MinGW
  56. Re: change encoding
  57. no privileges were granted
  58. Server not listening
  59. Recovering database after disk crash
  60. Strange behaviour - performance decreases after each TRUNCATE
  61. changing the endianness of a database
  62. rounding problems
  63. Re: Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
  64. pg_standby / WAL archive-restore through system restarts
  65. PHP Warning: pg_connect(): Unable to connect to PostgreSQL
  66. Returning RECORD from PGSQL without custom type?
  67. ORDER BY FIELD feature
  68. Making sure \timing is on
  69. How to create a function with multiple RefCursor OUT parameters
  70. Scripting function definitions as SQL?
  71. Problem returning strings with pgsql 8.3.x
  72. Returning RECORD from PGSQL without custom type?
  73. dynamic procedure call
  74. Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
  75. Slony-I testing, doc problems and master activity
  76. Duplicated primary key id happen
  77. Duplicated primary key id happen
  78. Is this a bug? (changing sequences in default value)
  79. reproducible database crash with simple sql command on postgres 8.3.1
  80. timestamps-accuracy
  81. Using Epoch to save timestamps in 4 bytes?
  82. changing language of system messages
  83. auto-vacuum questions
  84. regexp_replace in two times?
  85. statistics collector process is thrashing my cpu
  86. TSearch2 Searching Text with Synonyms and Stop Dictionary
  87. Custom Base Type in C
  88. Problems with memory
  89. Backup/Restore of single table in multi TB database
  90. pg_dumpall: pg_conversion table not saved
  91. Pl/;perl
  92. Problems with memory
  93. Re: Import German Decimal Numbers
  94. Import German Decimal Numbers
  95. How to run regression tests on windows
  96. ERROR: could not open relation
  97. Re: Cannot update table with OID with linked server in SQl Server
  98. xlogdump & pgview
  99. Is this possible in a trigger?
  100. Rules to provide a virtual column
  101. Cannot update table with OID with linked server in SQl Server
  102. GROUP BY, ORDER & LIMIT ?
  103. storing long live parameters
  104. CREATE CHARSET would be nice feature
  105. PostgreSQL 8.3.x Win32-Releases - always without psqlODBC?
  106. Autocast script of peter e in PostgreSQL 8.3
  107. Extract only numbers from a varchar column
  108. Re: Silent install 8.3 diiffers from 8.2
  109. more custom C function fun
  110. Re: more custom C function fun
  111. checkpoint_segments warning?
  112. psycopg2 and prepared statements
  113. bytea and character encoding when inserting escaped literals
  114. Archive_command
  115. operator varchar = integer
  116. Request for Materialized Views
  117. Race condition with notifications
  118. COPY Performance
  119. =?iso-2022-jp?B?GyRCOkZFWSEiNTkkNyQvJCo0aiQkJDckXiQ5ISMbKEI=? =
  120. SQL window functions
  121. Custom C function - is palloc broken?
  122. output array elements in rows
  123. Problems in queries
  124. Interesting comments about fsync on Linux
  125. User Defined C Function with minGW
  126. Speed up repetitive queries
  127. Feature request
  128. Problem revoking a user's 'create' privilege on schema public
  129. custom C function problem
  130. Unloading a table consistently
  131. Cannabis Misunderstood
  132. large query by offset and limt
  133. Re: Autovacuum
  134. Swap Space and vm.oom_kill_allocating_task
  135. Executing dynamic procedure call
  136. High resolution PostgreSQL Logo
  137. Autovacuum
  138. clustering without locking
  139. Problem revoking a user's 'create' privilege on schema public
  140. Text search with multiple tables
  141. question about join
  142. Compiling trigger function with MinGW
  143. SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall
  144. Full Text Search. In 8.3.1 How ?
  145. Trouble with text search select statement
  146. Benetl 1.8, free ETL tool using postgreSQL is out !!!
  147. Closed ResultSet error
  148. Performing a sub-query in a SELECT SUM aggregate.
  149. Quoting "
  150. complex query using postgresql
  151. Deadlock situation?
  152. Character Data Type 'Name'
  153. psql \pset pager
  154. Why is postgres autovacuuming a table that is never updated?
  155. Delete xml node from xml-document
  156. Multibyte (Japanese Character) Sorting
  157. question/problem concerning GRANT/REVOKE
  158. Re: passing a temporary table with more than one column to a stored procedure
  159. =?iso-2022-jp?B?GyRCOkZFWSEiNTkkNyQvJCo0aiQkJDckXiQ5ISMbKEI=? =
  160. PostGres Text Search
  161. =?us-ascii?Q?close=20database=2C=20nomount=20state?=
  162. Sorting nulls and empty strings together
  163. String Comparison and NULL
  164. passing a temporary table with more than one column to a stored procedure
  165. meaning of default_statistics_target
  166. varchar or text
  167. !!!!!!! interesting website here!!!!!
  168. =?Big5?B?pf6tu7Tks8zCcUlUIE1hbmFnZXIsICCzRMBZuauyt CwgplemcsDA?==?Big5?B?pvxlZG11bmQgeWF1LCC5cbjcwMCm/Dk3Mzk0NTY2LCBlbWFpbMDApvx5YXV0aW5ob0Bob3Rt?==?Big 5?B?YWlsLmNvbSwgZXlhdTEyM0BnbWFpbC5jb20sILr0p33AwK b8aHR0cDovL2VkbXVuZHlhdTEyMy5m?==?Big5?B?cmVlLXdl
  169. inheritance. more.
  170. inheritance...
  171. plpgsql functions and the planner
  172. taking actions on rollback (PHP)
  173. PITR problem
  174. Regular expression
  175. timestamp with time zone output incorrect
  176. status on pgiomonitor
  177. Unnecessary scan on a partial index slows down query dramatically
  178. Full Text Search
  179. pg_version is missing
  180. Last insert/update/delete time for a table
  181. TrueCrypt -> Forwarded from advocacy
  182. Re: query performance
  183. Re: query performance
  184. Re: query performance
  185. Re: query performance
  186. Confused by result of pg_catalog.format_type()
  187. Problems with postgresql 8.3 installation
  188. Multiple Database Strategy
  189. Adding notes against fields
  190. PAM + Password authentication
  191. Postgresql installation - cannot initdb 1
  192. I think this is a BUG?
  193. Best backup setup
  194. error connecting to database: could not open relation
  195. =?iso-2022-jp?B?GyRCJE8kOCRhJF4kNyRGInYbKEI=?=
  196. Column order
  197. query performance
  198. Table with differerent Data Types
  199. Stored procedures in C
  200. Create temporary function
  201. ROLAP visualization tool recommendations
  202. query question really cant give a summary here so read the body ;-)
  203. Vacuuming Questions
  204. Backup setup
  205. WAL shipping with archive_timeout & pg_switch_xlog()
  206. Qty of WAL files
  207. Qty of WAL files
  208. Deny creation of tables for a user
  209. initdb in 8.3
  210. Debian etch, backport postgresql 8.3 experiences?
  211. PG Yum Repo - can't Find Slony1
  212. help with "plpgsql"
  213. Need to update all my 60 million rows at once without transactionalintegrity
  214. Postgresql Help
  215. Best approach for large table maintenance
  216. tsearch2 problem
  217. Updating with a subselect
  218. Rapidly decaying performance repopulating a large table
  219. Can not restart postgres: Panic could not locate a valid checkpointrecord
  220. can't cast char to in
  221. Bitmap Heap Scan takes a lot of time
  222. better error handling for COPY from stdin
  223. How is statement level read consistency implemented?
  224. plpgsql and logical expression evaluation
  225. How to modify ENUM datatypes?
  226. Postgres Encoding conversion problem
  227. Schema migration tools?
  228. Re: FW: Re: create temp in function
  229. FW: Re: create temp in function
  230. create temp in function
  231. PostgreSQL on Vista
  232. Fwd: create temp in function
  233. Storing computed values
  234. Tsearch2 Spanish Dictionary
  235. Re: help with "plpgsql"
  236. Missing Log File
  237. Re: How to tell if 64 bit vs 32 bit engine?
  238. Insert Rewrite rules
  239. PostgreSQL over HTTP/REST interface
  240. Too many LWLocks taken in query using pg_tgrm & GIN index
  241. JDBC addBatch more efficient?
  242. Changed Hosts, Lots of Errors in PostgreSQL - HelpPlease!
  243. SQL error
  244. Initial ugly reverse-translator
  245. very slow updates in 8.3?
  246. No server after starting
  247. Upgrade 8.3
  248. Re: How to tell if 64 bit vs 32 bit engine?
  249. Re: How to tell if 64 bit vs 32 bit engine?
  250. good experience with performance in 8.2 for multi column indexes