PDA

View Full Version : Pgsql General

  1. Any big slony and WAL shipping users?
  2. M'I.5,Per secution BB C Newscast ers Li e & Deny The yre Wa tching Me
  3. M`I,5.Persec ution ` M I5 W aste Ta xpayer Million s on Pointl ess Hate-Campa ign
  4. M`I,5.Persecution - Fo ur Years of M I5 Pe rsecution Po sts on Int ernet Newsgr oups
  5. M I.5,Persecution Compar ing th e M I5 P ersecution wit h Ge rman Fi nal Soluti on
  6. Re: It's serious,Help!
  7. It's serious,Help!
  8. How to insert on duplicate key?
  9. copy database by copying datafiles ?
  10. Retrying transactions in serializable isolation level
  11. possible psql \d bug in 8.3 beta2
  12. Re: installation on Mac OS X 10.5.1
  13. WAL archive deletion methodology
  14. update pg question?
  15. Re: Constraint Trigger's referenced_table
  16. pg_get_serial_sequences still have problems with downcasting
  17. pg_ctl start fails on Windows
  18. how to alter an enum type
  19. installation on Mac OS X 10.5.1
  20. Constraint Trigger's referenced_table
  21. Setting Sequence Values
  22. Warm standby system - FATAL: the database system is starting up
  23. =?UTF-8?Q?Fwd:_Re:__SuSE_gcc_segfault_compiling_pgsql?=
  24. Hotel for FOSDEM 2008
  25. Exactly what is DEFERRABLE
  26. FK creation -- "ON DELETE NO ACTION" seems to be a no-op
  27. Requirements for Constraint Trigger's Function
  28. slow query
  29. self ordering list
  30. Restoring 8.0 db to 8.1
  31. Re: Deploy postgres - upgrade strategy
  32. Re: Deploy postgres - upgrade strategy
  33. Re:
  34. psql.bin: could not connect to server: No such file or directory
  35. Howto backup all functions?
  36. Re: Composite types for composite primary/foreign keys?
  37. Machine spec 64-bit/32 GB RAM
  38. change owner to all object in a schema
  39. Re: SuSE gcc segfault compiling pgsql
  40. Your opinion about PostgreSQL?
  41. pgsql cannot read utf8 files moved from windows correctly!
  42. Slony I - removing a replication set
  43. Quick Regex Question
  44. Change of the data directory on Ubuntu 7.04
  45. Re: Composite types for composite primary/foreignkeys?
  46. INDEX on a composite type
  47. Postgres 8.3 HOT and non-persistent xids
  48. Deploy postgres - upgrade strategy
  49. phpPgAdmin 4.2-Beta-1 translation status
  50. pgpool and slony
  51. Rich LIKE inheritance
  52. Re: Deploy postgres - upgrade strategy
  53. postgres UTC different from perl?
  54. Getting char * from timestamp in a composite type
  55. Problem with collector statistic
  56. referential integrity and defaults, DB design or trick
  57. Initdb problem - catch 22?
  58. Initdb problem - catch 22?
  59. Initdb problem - catch 22?
  60. Postgres from PHP in Leopard
  61. Trouble running PostgreSQL server / Server must be started under certain locale.
  62. Password as a command line argument to createuser
  63. to realise the dark side of Microsoft SQL Server...?
  64. foreign key constraint, planner ignore index.
  65. Specify client encoding for backups...
  66. free ETL tool using postgreSQL, new major release
  67. combining semi-duplicate rows
  68. multiple version installation in the same machine ????
  69. thank you
  70. Way to avoid expensive Recheck Cond in index lookup?
  71. insert into t1 (delete from t0 returning *)
  72. Restoring only some data from a backup file
  73. dblink does not connect when activated in a remote server
  74. Re: Problem with index not being chosen inside PL/PgSQL function...
  75. Re: Problem with index not being chosen inside PL/PgSQL function...
  76. logging arguments to prepared statements?
  77. Partitioned tables & Slony
  78. Trigger in partitioned table
  79. Is there PHP mysql_real_escape_string for postgresql?
  80. Many 8.3 server crashes in xmlCleanupCharEncodingHandlers()
  81. running Apple Mail on Postgres?
  82. spreadsheet interface
  83. Re: spreadsheet interface
  84. Limit record count
  85. install problem
  86. Re: Anomalia file FILBD.TXT
  87. slony error --need help
  88. postgres8.3beta encodding problem?
  89. Re: top posting
  90. Efficiency vs. code bloat for SELECT wrappers
  91. increasing checkpoint_timeout?
  92. postgres cannot access the server configuration file
  93. query pegs beta4
  94. about new feature
  95. Conditional updateable view
  96. Re: size cost for null fields
  97. Julian Day 0 question
  98. setting and using variables in PSQL ????
  99. postgres writer process growing up too much
  100. settings for 8.2.5 on Mac OS X 10.4.11
  101. How can i deal with "\n" when copy tables from sqlserver2005 to postgre?
  102. query
  103. user name and password woes
  104. rewrite pl/pgsql functions to c - remote job
  105. pgsql constraints and temporal tables
  106. Re: Planner ignoring to use INDEX SCAN
  107. Planner ignoring to use INDEX SCAN
  108. plpgsql trigger coredumps instance
  109. HouseKeeping and vacuum Questions
  110. COPY speedup
  111. extend "group by" to include "empty relations" ?
  112. Finding bad bye in "invalid byte sequence" error
  113. autovacuum log?
  114. Re: timestamp with time zone
  115. UNION not working... why?
  116. Hash join in 8.3
  117. SQL Query
  118. accessing multiple databases using dblink
  119. Need to find out which process is hitting hda
  120. Hot Christmas Shopping,Travel,And Entertainment Marketplace
  121. timestamp with time zone
  122. timestamp with time zone
  123. For the SQL gurus out there
  124. Need LIMIT and ORDER BY for UPDATE
  125. mssql migration and boolean to integer problems
  126. Insert/Update/Delete views with INSTEAD OF
  127. Extract last 4 characters from string?
  128. Altering field passed as parameter to plpgsql trigger
  129. jdbc lob and postgresql
  130. Re: Function to convert from TEXT to BYTEA?
  131. General Q's
  132. Re: General Q's
  133. Re: General Q's
  134. data type change on a view
  135. slony1 replication question
  136. Would it be OK if I put db file on a ext2 filesystem?
  137. copy a large table raises out of memory exception
  138. How can I insert NULL into column with the type of timestamp?
  139. Better alternative for Primary Key then serial??
  140. convert function
  141. fiori zanella
  142. executing a procedure with delay
  143. Southern California Linux Expo
  144. Instaltiating an ARRAY within a function
  145. LIBPQ Exception
  146. very slow query
  147. index organized tables use case
  148. Possible bug in PostgreSQL 8.3beta4 (postgres process segfaults)
  149. Would it be OK if I put db file on a ext2 filesystem?
  150. Moving stats files results
  151. Terminology definitions/meaning
  152. Re: POSIX and libpq
  153. RETURNING clause: how to specifiy column indexes?
  154. Multiple clusters on one box for PITR
  155. Function to convert from TEXT to BYTEA?
  156. Creating Aggregate functions in PLpgSQL
  157. Slow PITR restore
  158. Dumb question about binary cursors and #ifdef HAVE_INT64_TIMESTAMP
  159. Re: Understanding Aliases
  160. Re: POSIX and libpq
  161. Oddity in column specifications for table creation
  162. Trigger - will not perform INSERT
  163. Version Upgrade using WAL files ?
  164. psql batch file question
  165. POSIX and libpq
  166. if exists...does it exists for insert statments?
  167. Using hashtext and unique constraints together
  168. WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
  169. Hijack!
  170. question about warm standby databases in 8.2.5
  171. Understanding Aliases
  172. Ignored btree indexes on particular tables.
  173. how to create aggregate xml document in 8.3?
  174. Re: Understanding Aliases
  175. comparing rows
  176. VTD-XML Tutorial by Code Examples Posted Options
  177. Unable to ALTER table after SELECT data from table
  178. Unable to ALTER table after SELECT data from table
  179. TIMESTAMP difference
  180. Planner not using UNIQUEness of index properly
  181. Creating indexes
  182. slony question
  183. Log statement length limit
  184. Query
  185. Problems with acessing xml functions on other database
  186. about the performance of autovacuum and vacuumdb?
  187. insert into...
  188. postgresql startup
  189. wriring a file to a database
  190. function permissions question
  191. sequence
  192. list of roles
  193. returning columns from different tables, in plpgsql function
  194. Returning columns from different tables, in plpgsql function
  195. Re: Slony replication
  196. partitioned table query question
  197. pgagent on a mac
  198. Array index not used for query on first element?
  199. Column pgl.transaction does not exist in 8.3 beta 4
  200. Identifying casts
  201. Pg_catalog reference
  202. Replication using WAL files
  203. pg_dump
  204. How to EXPLAIN statements inside a trigger function?
  205. Killing a session in windows
  206. =?us-ascii?Q?cannot=20dump=20structures?=
  207. Determining current block size?
  208. Q: using generate_series to fill in the blanks
  209. Error accessing db with psql
  210. Determining current block size?
  211. aggregate and order by
  212. Replication Monitoring
  213. SQL design pattern for a delta trigger?
  214. Improving the timing of a query
  215. Continual Postgres headaches...
  216. Re: record-based log shipping
  217. Why autovacuum in not running
  218. reformatting floats ?
  219. record-based log shipping
  220. Thanks for using your bank account!
  221. Question in dblink
  222. Unreasonable size of table pg 8.2.5
  223. Orthodox use of PQtransactionStatus
  224. Re: WAL shipping question
  225. simple update on boolean
  226. Import LDAP data to a Postgres database
  227. Error in creating function
  228. Understanding how partial indexes work?
  229. autovacuum is stopping automatically....
  230. elegant way to fill a table with serial
  231. Thanks for using your bank account!
  232. Re: WAL shipping question
  233. pgAccess for PostgreSQL 8.2.5
  234. 7.4 end of life
  235. Re: Avoid huge perfomance loss on string concatenation
  236. storage size of "bit" data type..
  237. buy brand shoes(www.24hoursneakers.com)
  238. we accept paypal www.24hoursneakers.com
  239. pg_dump and server responsiveness
  240. Problem with joining two tables
  241. elegant way to fill a table with serial
  242. 8.3 beta FATAL: invalid value for parameter "timezone_abbreviations": "Default"
  243. pg_dump: could not format inet value
  244. Re: pg_dump: could not format inet value
  245. SQL Query
  246. thesaurus support in postgresql
  247. Server crashed and now experiencing slow running queries
  248. Conservative postgresql.conf made by initdb?
  249. Nested loop in simple query taking long time
  250. how to redirect output to a file