pgsql-general since 2011-05-27 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

May 27, 2011

Thread Author Time
unnest with generate_subscripts and same array Carlos Fuentes 00:17
Re: unnest with generate_subscripts and same array David Johnston 00:58
Re: 500KB PDF saving into large object , what is the table size? Jasen Betts 03:53
Re: Access to postgres conversion Jasen Betts 03:57
Re: "full_page_writes" makes no difference? Tian Luo 04:24
Re: copy record? Jasen Betts 04:45
Feature request: Replicate only parts of a database A B 04:53
Re: unnest with generate_subscripts and same array David Fetter 05:09
Re: PostgreSQL 8.4.8 bringing my website down every evening Albe Laurenz 06:43
Re: max_connections proposal Cédric Villemain 08:09
Re: max_connections proposal Stuart Bishop 09:08
Re: Feature request: Replicate only parts of a database Peter Geoghegan 09:58
Re: Feature request: Replicate only parts of a database Andrew Sullivan 10:54
Re: Is there any problem with pg_notify and memory consumption? Tom Lane 15:28
Re: syntax for updating an aliased table Andy Chambers 15:36
Re: copy record? Merlin Moncure 15:39
Re: Is there any problem with pg_notify and memory consumption? Simon Riggs 15:42
Re: Is there any problem with pg_notify and memory consumption? Tom Lane 15:43
adding applications to the stack builder Gaetano Giunta 15:59
500KB PDF files for postgresql8.3, which is the most efficient way? Emi Lu 16:12
Re: Is there any problem with pg_notify and memory consumption? 📎 Per-Olov Esgard 16:12
Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Emi Lu 16:15
Re: Is there any problem with pg_notify and memory consumption? Merlin Moncure 16:15
Re: Is there any problem with pg_notify and memory consumption? Tom Lane 16:19
SELECT COUNT(*) execution time on large tables (v9.0.4-1) Carlos Sotto Maior (SIM) 16:41
Inspecting a DB - psql or system tables ? Andre Majorel 17:24
Re: Inspecting a DB - psql or system tables ? fork 17:57
Re: Inspecting a DB - psql or system tables ? Tomas Vondra 18:26
Re: Inspecting a DB - psql or system tables ? Andrew Sullivan 18:31
Re: trigger - dynamic WHERE clause Tarlika Elisabeth Schmitz 19:01
Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Samuel Gendler 19:28
Shared Buffer Size preetika tyagi 19:36
Re: SELECT COUNT(*) execution time on large tables (v9.0.4-1) David Johnston 20:48
Re: Shared Buffer Size Derrick Rice 21:11
String library Little, Douglas 21:14
Re: Shared Buffer Size preetika tyagi 21:33

May 28, 2011

Thread Author Time
Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Piotr Czekalski 07:58
Re: Shared Buffer Size Carl von Clausewitz 08:42
Re: Postgres questions Trenta sis 10:08
Re: Postgres questions Craig Ringer 11:49
Regular disk activity of an idle DBMS Andrej Podzimek 15:02
How to check a table content efficiently? With LIMIT and OFFSET? Stefan Keller 19:13
Re: Shared Buffer Size preetika tyagi 19:24
Re: How to check a table content efficiently? With LIMIT and OFFSET? Stefan Keller 21:45

May 29, 2011

Thread Author Time
Re: Shared Buffer Size Greg Smith 02:05
Re: Shared Buffer Size Greg Smith 02:12
Re: How to check a table content efficiently? With LIMIT and OFFSET? Craig Ringer 02:32
Re: max_connections proposal Greg Smith 02:33
Re: max_connections proposal Edison So 02:44
Re: Inspecting a DB - psql or system tables ? Greg Smith 02:45
Re: SELECT COUNT(*) execution time on large tables (v9.0.4-1) Greg Smith 02:54
timeouts on transactions etc? Darren Duncan 02:55
Re: Regular disk activity of an idle DBMS Greg Smith 03:02
Re: timeouts on transactions etc? Steve Atkins 03:35
Re: Bidirectional replication Greg Sabino Mullane 03:42
Re: timeouts on transactions etc? Darren Duncan 03:52
Re: max_connections proposal Craig Ringer 08:39
Re: max_connections proposal Craig Ringer 08:45
[No subject] Tareq Tajkeh 13:17
Re: Rename a constraint Thom Brown 13:20
Re: Rename a constraint Tom Lane 15:12
Re: Rename a constraint Thom Brown 15:24
Re: How to check a table content efficiently? With LIMIT and OFFSET? Stefan Keller 17:45
Re: Regular disk activity of an idle DBMS Andrej Podzimek 18:42
Re: max_connections proposal Edison So 19:26
database field list Seb 21:04
Re: database field list Thomas Kellerer 21:11
Re: How to check a table content efficiently? With LIMIT and OFFSET? Alban Hertroys 21:12
Re: database field list Seb 21:27
Re: How to check a table content efficiently? With LIMIT and OFFSET? Stefan Keller 21:55
Re: max_connections proposal Craig Ringer 23:27
Re: How to check a table content efficiently? With LIMIT and OFFSET? Craig Ringer 23:35

May 30, 2011

Thread Author Time
Re: max_connections proposal Edison So 00:19
Re: max_connections proposal Scott Marlowe 00:46
Re: How to check a table content efficiently? With LIMIT and OFFSET? Jaime Casanova 01:26
Re: Regular disk activity of an idle DBMS Greg Smith 01:31
Re: Shared Buffer Size Toby Corkindale 03:10
Re: Shared Buffer Size Carl von Clausewitz 05:34
Re: Is there any problem with pg_notify and memory consumption? Per-Olov Esgard 05:52
Re: Regular disk activity of an idle DBMS Scott Marlowe 06:21
Re: How to check a table content efficiently? With LIMIT and OFFSET? Alban Hertroys 06:45
Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way? Enrico Weigelt 07:39
determine database and tables from deadlock Machiel Richards 07:45
Universal certificate for verify-full ssl connection Asia 07:58
Re: trigger - dynamic WHERE clause Pavel Stehule 09:02
Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs Leif Jensen 09:36
Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs Leif Jensen 09:48
pgpool-II 3.0.4 release delayed Tatsuo Ishii 10:35
Re: Shared Buffer Size Cédric Villemain 10:41
time estimation for a test salah jubeh 10:51
Re: How to check a table content efficiently? With LIMIT and OFFSET? Stefan Keller 11:37
[No subject] Sairam Krishnamurthy 12:35
Index Size Nick Raj 12:53
Re: Inspecting a DB - psql or system tables ? Nicholson, Brad (Toronto, ON, CA) 13:08
deadlock problem Sebastian Böhm 14:04
UTC4115FATAL: the database system is in recovery mode Mathew Samuel 14:29
Re: Regular disk activity of an idle DBMS Andrej Podzimek 16:52
RES: SELECT COUNT(*) execution time on large tables (v9.0.4-1) Carlos Sotto Maior (SIM) 18:35
Function Column Expansion Causes Inserts To Fail David Johnston 21:09
Re: determine database and tables from deadlock Craig Ringer 23:17
Re: trigger - dynamic WHERE clause Tarlika Elisabeth Schmitz 23:20
Re: Universal certificate for verify-full ssl connection Craig Ringer 23:20
Re: Index Size Craig Ringer 23:23
Re: deadlock problem Craig Ringer 23:35
Re: UTC4115FATAL: the database system is in recovery mode Craig Ringer 23:51

May 31, 2011

Thread Author Time
[9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters David Johnston 01:04
Re: UTC4115FATAL: the database system is in recovery mode Tom Lane 02:14
Re: [9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters Tom Lane 02:39
Re: Function Column Expansion Causes Inserts To Fail Tom Lane 03:09
Re: Index Size Tom Lane 03:20
Re: Shared Buffer Size Toby Corkindale 03:20
Re: Index Size Nick Raj 03:33
Re: trigger - dynamic WHERE clause Pavel Stehule 04:09
Re: Index Size 📎 Craig Ringer 06:22
Universal certificate for verify-full ssl connection Asia 07:40
Re: RES: SELECT COUNT(*) execution time on large tables (v9.0.4-1) salah jubeh 07:58
Re: Universal certificate for verify-full ssl connection Craig Ringer 08:06
Re: Universal certificate for verify-full ssl connection Magnus Hagander 08:52
Re: trigger - dynamic WHERE clause Tarlika Elisabeth Schmitz 09:51
Re: trigger - dynamic WHERE clause Pavel Stehule 10:38
Re: Universal certificate for verify-full ssl connection Magnus Hagander 10:46
Re: Shared Buffer Size Cédric Villemain 11:12
Re: Shared Buffer Size Cédric Villemain 11:15
Re: Regular disk activity of an idle DBMS 📎 andrej 13:55
Re: [9.1beta1] UTF-8/Regex Word-Character Definition excluding accented letters David Johnston 13:59
Re: Function Column Expansion Causes Inserts To Fail David Johnston 14:24
Re: UTC4115FATAL: the database system is in recovery mode Mathew Samuel 14:46
troubles with initdb jlhgis 15:16
Re: Function Column Expansion Causes Inserts To Fail Merlin Moncure 15:56
Re: troubles with initdb Raymond O'Donnell 16:19
Some clarification about TIMESTAMP hernan gonzalez 16:45
"postgresql-9.0-801.jdbc4.jar" always cause "org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled" Exception Emi Lu 16:51
Re: Function Column Expansion Causes Inserts To Fail David Johnston 16:57
Re: "postgresql-9.0-801.jdbc4.jar" always cause "org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled" Exception David Johnston 17:42
Re: Some clarification about TIMESTAMP David Johnston 18:04
Re: "postgresql-9.0-801.jdbc4.jar" always cause "org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled" Exception Emi Lu 18:05
Re: "postgresql-9.0-801.jdbc4.jar" always cause "org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled" Exception David Johnston 18:16
Re: Some clarification about TIMESTAMP Tom Lane 18:40
Re: Some clarification about TIMESTAMP hernan gonzalez 19:00
Re: Some clarification about TIMESTAMP Scott Marlowe 19:13
Re: Function Column Expansion Causes Inserts To Fail Merlin Moncure 19:15
Re: Some clarification about TIMESTAMP Adrian Klaver 19:59
Re: Function Column Expansion Causes Inserts To Fail Tom Lane 20:28
UTF-8 and Regular expression Håvard Wahl Kongsgård 20:42
PG_RESTORE salah jubeh 20:42
Re: Some clarification about TIMESTAMP Andrew Sullivan 20:50
Consistency of distributed transactions Pete Chown 20:52
Re: UTF-8 and Regular expression Tom Lane 21:26
Re: Function Column Expansion Causes Inserts To Fail Merlin Moncure 21:42
Re: Function Column Expansion Causes Inserts To Fail Tom Lane 22:01
Re: Function Column Expansion Causes Inserts To Fail Merlin Moncure 22:15

June 1, 2011

Thread Author Time
Re: UTC4115FATAL: the database system is in recovery mode Craig Ringer 00:08
Re: troubles with initdb Craig Ringer 00:14
Re: Postgres 8.3.5 - ECPG and the use of descriptors and cursors in multi-threaded programs Bosco Rama 00:35
Re: troubles with initdb jlhgis 01:17
Re: Consistency of distributed transactions Craig Ringer 01:29
search_path versus dynamic CREATE SCHEMA Brendan Jurd 02:25
Re: troubles with initdb Craig Ringer 02:26
Re: search_path versus dynamic CREATE SCHEMA Tom Lane 03:08
Re: Consistency of distributed transactions Rob Sargent 03:11
Re: Consistency of distributed transactions Craig Ringer 03:39
Psql Internal Variable question Prafulla Tekawade 03:49
Psql Internal Variable question Prafulla Tekawade 03:52
Re: search_path versus dynamic CREATE SCHEMA Brendan Jurd 03:55
Re: Psql Internal Variable question Pavel Stehule 07:14
Need suggestion Carl von Clausewitz 08:08
Returning from insert on view Aleksey Chirkin 09:32
Re: Consistency of distributed transactions Pete Chown 12:18
Mixed up protocol packets in server response? Michal Politowski 13:06
How do I repair a corrupted system table in PostgreSQL? David Hamilton 13:24
Re: troubles with initdb jlhgis 14:09
Re: Mixed up protocol packets in server response? Tom Lane 14:11
currval = currval+1 salah jubeh 14:27
Re: currval = currval+1 Merlin Moncure 14:54
Re: currval = currval+1 salah jubeh 15:22
Re: currval = currval+1 Merlin Moncure 15:43
Re: currval = currval+1 Tom Lane 15:52
proper regex_replace() syntax Geoffrey Myers 17:22
Re: Some clarification about TIMESTAMP Steve Crawford 17:54
Re: proper regex_replace() syntax Ken Tanzer 18:40
Re: proper regex_replace() syntax Rick Genter 18:43
SELECT to_timestamp crash PostgreSQL 9.1beta1 Paolo Saudin 19:15
Column aliases in having or where for Postgres 8.3 Prafulla Tekawade 22:08
Table with active and historical data Robert James 23:30

June 2, 2011

Thread Author Time
Re: Mixed up protocol packets in server response? Craig Ringer 00:50
Re: Table with active and historical data Merlin Moncure 01:56
Re: SELECT to_timestamp crash PostgreSQL 9.1beta1 Craig Ringer 02:32
DBD::PG and long running queries and tcp stack timeout Clemens Schwaighofer 06:35
DBD::PG and long running queries and tcp stack timeout Clemens Schwaighofer 07:02
Re: DBD::PG and long running queries and tcp stack timeout John R Pierce 07:11
Re: DBD::PG and long running queries and tcp stack timeout Clemens Schwaighofer 07:56
Re: Returning from insert on view Dean Rasheed 08:12
Question about configuration and SSD Szymon Guz 08:26
Re: Question about configuration and SSD Craig Ringer 08:53
Re: Need suggestion Ognjen Blagojevic 09:19
Re: Need suggestion Carl von Clausewitz 10:22
Re: Table with active and historical data salah jubeh 10:50
Re: Access to postgres conversion Thomas Harold 13:32
using jboss with ident auth eyal edri 13:54
Re: Access to postgres conversion akp geek 14:01

Browse Archives

Prev | Next