PDA

View Full Version : Pgsql General

  1. How to create a function with multiple RefCursor OUT parameters
  2. Scripting function definitions as SQL?
  3. Problem returning strings with pgsql 8.3.x
  4. Returning RECORD from PGSQL without custom type?
  5. Hung SQL Update Linux Redhat 4U5 Postgres 8.3.1
  6. Duplicated primary key id happen
  7. Slony-I testing, doc problems and master activity
  8. dynamic procedure call
  9. Duplicated primary key id happen
  10. Is this a bug? (changing sequences in default value)
  11. timestamps-accuracy
  12. reproducible database crash with simple sql command on postgres 8.3.1
  13. Using Epoch to save timestamps in 4 bytes?
  14. changing language of system messages
  15. auto-vacuum questions
  16. regexp_replace in two times?
  17. statistics collector process is thrashing my cpu
  18. TSearch2 Searching Text with Synonyms and Stop Dictionary
  19. Custom Base Type in C
  20. Backup/Restore of single table in multi TB database
  21. Problems with memory
  22. pg_dumpall: pg_conversion table not saved
  23. Pl/;perl
  24. Problems with memory
  25. Re: Import German Decimal Numbers
  26. Import German Decimal Numbers
  27. How to run regression tests on windows
  28. ERROR: could not open relation
  29. Re: Cannot update table with OID with linked server in SQl Server
  30. xlogdump & pgview
  31. Is this possible in a trigger?
  32. Cannot update table with OID with linked server in SQl Server
  33. Rules to provide a virtual column
  34. GROUP BY, ORDER & LIMIT ?
  35. storing long live parameters
  36. CREATE CHARSET would be nice feature
  37. PostgreSQL 8.3.x Win32-Releases - always without psqlODBC?
  38. Autocast script of peter e in PostgreSQL 8.3
  39. Extract only numbers from a varchar column
  40. Re: Silent install 8.3 diiffers from 8.2
  41. more custom C function fun
  42. Re: more custom C function fun
  43. checkpoint_segments warning?
  44. psycopg2 and prepared statements
  45. bytea and character encoding when inserting escaped literals
  46. Archive_command
  47. operator varchar = integer
  48. Request for Materialized Views
  49. Race condition with notifications
  50. COPY Performance
  51. =?iso-2022-jp?B?GyRCOkZFWSEiNTkkNyQvJCo0aiQkJDckXiQ5ISMbKEI=? =
  52. SQL window functions
  53. Custom C function - is palloc broken?
  54. output array elements in rows
  55. Problems in queries
  56. Interesting comments about fsync on Linux
  57. User Defined C Function with minGW
  58. Feature request
  59. Speed up repetitive queries
  60. Problem revoking a user's 'create' privilege on schema public
  61. custom C function problem
  62. Unloading a table consistently
  63. Cannabis Misunderstood
  64. large query by offset and limt
  65. Re: Autovacuum
  66. Executing dynamic procedure call
  67. Swap Space and vm.oom_kill_allocating_task
  68. Autovacuum
  69. High resolution PostgreSQL Logo
  70. Problem revoking a user's 'create' privilege on schema public
  71. clustering without locking
  72. Text search with multiple tables
  73. question about join
  74. Compiling trigger function with MinGW
  75. SSL SYSCALL error: A blocking operation was interrupted by a call to WSACancelBlockingCall
  76. Full Text Search. In 8.3.1 How ?
  77. Trouble with text search select statement
  78. Benetl 1.8, free ETL tool using postgreSQL is out !!!
  79. Closed ResultSet error
  80. Performing a sub-query in a SELECT SUM aggregate.
  81. Quoting "
  82. complex query using postgresql
  83. Deadlock situation?
  84. Character Data Type 'Name'
  85. psql \pset pager
  86. Why is postgres autovacuuming a table that is never updated?
  87. Delete xml node from xml-document
  88. Multibyte (Japanese Character) Sorting
  89. question/problem concerning GRANT/REVOKE
  90. Re: passing a temporary table with more than one column to a stored procedure
  91. =?iso-2022-jp?B?GyRCOkZFWSEiNTkkNyQvJCo0aiQkJDckXiQ5ISMbKEI=? =
  92. PostGres Text Search
  93. =?us-ascii?Q?close=20database=2C=20nomount=20state?=
  94. Sorting nulls and empty strings together
  95. String Comparison and NULL
  96. passing a temporary table with more than one column to a stored procedure
  97. meaning of default_statistics_target
  98. varchar or text
  99. !!!!!!! interesting website here!!!!!
  100. =?Big5?B?pf6tu7Tks8zCcUlUIE1hbmFnZXIsICCzRMBZuauyt CwgplemcsDA?==?Big5?B?pvxlZG11bmQgeWF1LCC5cbjcwMCm/Dk3Mzk0NTY2LCBlbWFpbMDApvx5YXV0aW5ob0Bob3Rt?==?Big 5?B?YWlsLmNvbSwgZXlhdTEyM0BnbWFpbC5jb20sILr0p33AwK b8aHR0cDovL2VkbXVuZHlhdTEyMy5m?==?Big5?B?cmVlLXdl
  101. inheritance. more.
  102. inheritance...
  103. plpgsql functions and the planner
  104. taking actions on rollback (PHP)
  105. PITR problem
  106. Regular expression
  107. timestamp with time zone output incorrect
  108. status on pgiomonitor
  109. Unnecessary scan on a partial index slows down query dramatically
  110. Full Text Search
  111. pg_version is missing
  112. Last insert/update/delete time for a table
  113. TrueCrypt -> Forwarded from advocacy
  114. Re: query performance
  115. Re: query performance
  116. Re: query performance
  117. Re: query performance
  118. Confused by result of pg_catalog.format_type()
  119. Problems with postgresql 8.3 installation
  120. Multiple Database Strategy
  121. Adding notes against fields
  122. PAM + Password authentication
  123. Postgresql installation - cannot initdb 1
  124. I think this is a BUG?
  125. Best backup setup
  126. error connecting to database: could not open relation
  127. =?iso-2022-jp?B?GyRCJE8kOCRhJF4kNyRGInYbKEI=?=
  128. Column order
  129. query performance
  130. Table with differerent Data Types
  131. Stored procedures in C
  132. Create temporary function
  133. ROLAP visualization tool recommendations
  134. query question really cant give a summary here so read the body ;-)
  135. Vacuuming Questions
  136. Backup setup
  137. WAL shipping with archive_timeout & pg_switch_xlog()
  138. Qty of WAL files
  139. Qty of WAL files
  140. Deny creation of tables for a user
  141. initdb in 8.3
  142. Debian etch, backport postgresql 8.3 experiences?
  143. PG Yum Repo - can't Find Slony1
  144. help with "plpgsql"
  145. Need to update all my 60 million rows at once without transactionalintegrity
  146. Postgresql Help
  147. Best approach for large table maintenance
  148. tsearch2 problem
  149. Updating with a subselect
  150. Rapidly decaying performance repopulating a large table
  151. Can not restart postgres: Panic could not locate a valid checkpointrecord
  152. can't cast char to in
  153. Bitmap Heap Scan takes a lot of time
  154. better error handling for COPY from stdin
  155. How is statement level read consistency implemented?
  156. plpgsql and logical expression evaluation
  157. How to modify ENUM datatypes?
  158. Postgres Encoding conversion problem
  159. Schema migration tools?
  160. Re: FW: Re: create temp in function
  161. FW: Re: create temp in function
  162. create temp in function
  163. PostgreSQL on Vista
  164. Fwd: create temp in function
  165. Storing computed values
  166. Tsearch2 Spanish Dictionary
  167. Re: help with "plpgsql"
  168. Missing Log File
  169. Re: How to tell if 64 bit vs 32 bit engine?
  170. Insert Rewrite rules
  171. PostgreSQL over HTTP/REST interface
  172. Too many LWLocks taken in query using pg_tgrm & GIN index
  173. JDBC addBatch more efficient?
  174. Changed Hosts, Lots of Errors in PostgreSQL - HelpPlease!
  175. SQL error
  176. Initial ugly reverse-translator
  177. very slow updates in 8.3?
  178. No server after starting
  179. Upgrade 8.3
  180. Re: How to tell if 64 bit vs 32 bit engine?
  181. Re: How to tell if 64 bit vs 32 bit engine?
  182. good experience with performance in 8.2 for multi column indexes
  183. Client Authentication
  184. Re: In the belly of the beast (MySQLCon)
  185. Re: In the belly of the beast (MySQLCon)
  186. Re: In the belly of the beast (MySQLCon)
  187. Re: In the belly of the beast (MySQLCon)
  188. problem with tsearch and utf-8 on postgresql 8.1
  189. Re: Problems running PostGreSQL silent install
  190. Using meta-data for foreign key?
  191. Unable to add a new column to a table named "in" (look like a bug ...)
  192. Duplicate Symbols - Compiler Warnings
  193. String concat issues in 8.3.1 (8.3.1 bug?)
  194. pg 8.3.0 unexpected sending network packet?
  195. Binary bytea to literal strings
  196. Curiosity with catalog table array attribute index dimensions
  197. ALTER TABLE DDL Triggers?
  198. How to retore a pg_dumpall dump?
  199. How do I measure user disk usage on Postgresql table?
  200. table as log (multiple writers and readers)
  201. "vacuum" and "cluster"
  202. "vacuum" and "cluster"
  203. Master-master replication with PostgreSQL
  204. Re: Storing and accessing GeoData( Latitude and Longitude) in PostgreSQL 8.3
  205. Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3
  206. Need help to clean up after failed CLUSTER
  207. How to recovery data from folder data installation?
  208. I need to ecrypt one column to an output file
  209. Help needed in PITR
  210. util/int8.h: missing int8_text() function
  211. strange dump problem
  212. Suggestion for psql command interpretation
  213. session_replication_role
  214. Not Geography
  215. Which Python library - psycopg2 or pygresql?
  216. precompilers
  217. Re: PostgreSQL 8.3 XML parser seems not torecognize the DOCTYPE element in XML files
  218. Installation of contrib/tablefunc - problems
  219. Copying large object in a stored procedure
  220. COPY to STDOUT and pipes
  221. Storage sizes for dates/times (documentation bug?)
  222. Re: How do I make sure that an employee and supervisor belong to the same company?
  223. Verifying SSL Certificate on the Client Side
  224. How do I make sure that an employee and supervisor belong to the same company?
  225. two not null columns
  226. Unacceptable postgres performance vs. Microsoft sqlserver
  227. generate_series woes
  228. how to get pg_restore to continue if an error occurs
  229. The default text search configuration will be set to "simple" ?
  230. No Return??
  231. VACUUM hanging on PostgreSQL 8.3.1 for larger tables
  232. Post-installation questions
  233. rule to update view that inserts into log
  234. Problems in PITR backup&recovery
  235. Re: Problem. createdb: could not connect to database postgres: could not connect to server: No such file or directory
  236. Re: Problem. createdb: could not connect to database postgres:
  237. Problems in PITR backup&recovery
  238. Deleting row in 7.4 takes for ever
  239. SQL injection, php and queueing multiple statement
  240. tsearch2 and hyphenated terms
  241. Re: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
  242. createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
  243. PostgreSQL Processes on a linux box
  244. Operator COMMUTATOR - how does postgresql use this information
  245. PG 8.3 review in Linux Mag
  246. PostgresSQL on a networked drive with multiple users
  247. Re: how to use transaction isolation
  248. Postgres on shared network drive
  249. Date / interval question
  250. pgcrypto and dblink