Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-general - February 2012

2012-02-01

• Re: [GENERAL] pg_dump -s dumps data?! Andrew Dunstan (04:10)
• Sequence Ids are not updating after COPY operation in PostgreSQL Siva Palanisamy (06:38)
• Re: Sequence Ids are not updating after COPY operation in PostgreSQL Guillaume Lelarge (07:50)
• How do clients failover in hot standby/SR? Herouth Maoz (10:28)
• Re: How do clients failover in hot standby/SR? Andreas Kretschmer (10:48)
• Server not starting problem Pablo Fulco (13:44)
• Re: Help speeding up a left join aggregate Volodymyr Kostyrko (13:45)
• Re: Why Hard-Coded Version 9.1 In Names? Bobby Dewitt (14:28)
• Re: parameter "vacuum_defer_cleanup_age" Marti Raudsepp (14:33)
• Issue with CREATE EXTENSION tablefuncKreiter Chris Travers (14:52)
• Re: Issue with CREATE EXTENSION tablefuncKreiter Merlin Moncure (14:58)
• Expanding psql variables mephysto (15:24)
• Re: Issue with CREATE EXTENSION tablefuncKreiter Tom Lane (15:52)
• Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation Tom Lane (16:13)
• Re: Issue with CREATE EXTENSION tablefuncKreiter Philip Rhoades (17:06)
• Re: Server not starting problem Guillaume Lelarge (17:38)
• Re: Question about (probably wrong) index scan cost for conditional indexes Alex Lai (19:21)
• Re2: Robert Buckley (20:07)
• Re: pg_dump -s dumps data?! Dimitri Fontaine (21:02)
• Re: Issue with CREATE EXTENSION tablefuncKreiter Tom Lane (21:31)
• Audtiting, DDL and DML in same SQL Function Christian Ramseyer (22:29)
• Re: Audtiting, DDL and DML in same SQL Function Scott Marlowe (23:27)
• Re: Audtiting, DDL and DML in same SQL Function Scott Marlowe (23:39)
• Re: Issue with CREATE EXTENSION tablefuncKreiter Chris Travers (23:43)

2012-02-02

• Puzzling full database lock Christopher Opena (00:38)
• Re: Puzzling full database lock Carlos Mennens (00:44)
• Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation Adrian Klaver (00:46)
• Re: Puzzling full database lock Christopher Opena (00:51)
• Re: Puzzling full database lock Carlos Mennens (00:55)
• Re: Puzzling full database lock Alan Hodgson (00:55)
• Re: restart server on Lion Scott Frankel (00:55)
• Re: Puzzling full database lock Christopher Opena (00:58)
• Re: Puzzling full database lock Ondrej Ivanič (01:12)
• Re: Puzzling full database lock Christopher Opena (01:13)
• Re: Puzzling full database lock Alan Hodgson (04:42)
• Re: Puzzling full database lock Christopher Opena (05:56)
• What is the best way to force character data to upper case Dennis (06:09)
• [GENERA]: Postgresql-9.1.1 synchronous replication issue Venkat Balaji (06:51)
• Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue Raghavendra (07:01)
• Re: Why Hard-Coded Version 9.1 In Names? Gregg Jaskiewicz (07:23)
• Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue Venkat Balaji (07:50)
• Re: Audtiting, DDL and DML in same SQL Function Dean Rasheed (09:32)
• Facing issue in online recovery of pgpool-II Saurabh (10:26)
• Re: pg_dump -s dumps data?! hubert depesz lubaczewski (11:24)
• Deadlock report bdmytrak@eranet.pl (11:30)
• Is it possible to speed up addition of "not null"? hubert depesz lubaczewski (11:48)
• Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation Nykolyn, Andy (AS) (11:51)
• Re: Is it possible to speed up addition of "not null"? Andrew Sullivan (12:26)
• Re: parameter "vacuum_defer_cleanup_age" Tulio (12:50)
• Re: Is it possible to speed up addition of "not null"? hubert depesz lubaczewski (13:20)
• Re: Puzzling full database lock Merlin Moncure (14:03)
• Re: Is it possible to speed up addition of "not null"? Florian Weimer (14:08)
• Re: Puzzling full database lock Florian Weimer (14:11)
• Re: Is it possible to speed up addition of "not null"? hubert depesz lubaczewski (14:23)
• Re: Is it possible to speed up addition of "not null"? Florian Weimer (14:30)
• Re: Audtiting, DDL and DML in same SQL Function Christian Ramseyer (14:45)
• Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue Adrian Klaver (15:07)
• Re: Is it possible to speed up addition of "not null"? Andrew Sullivan (15:11)
• 9.0 EXPLAIN Buffers: written=nnnn david.sahagian (17:03)
• Re: 9.0 EXPLAIN Buffers: written=nnnn Rodrigo Gonzalez (17:37)
• xlog min recovery request ... is past current point ... Christophe Pettus (18:59)
• Functions To Let Users Cancel/Terminate own Back Ends David E. Wheeler (22:38)
• Re: Functions To Let Users Cancel/Terminate own Back Ends Magnus Hagander (22:51)
• Re: Functions To Let Users Cancel/Terminate own Back Ends David E. Wheeler (23:00)

2012-02-03

• Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue Venkat Balaji (06:21)
• Temporal foreign keys Matthias (06:58)
• Understanding EXPLAIN Robert Lichtenberger (07:50)
• Re: Understanding EXPLAIN Tom Lane (08:20)
• Re: Understanding EXPLAIN Andreas Kretschmer (08:22)
• last entry per person garry (08:26)
• Re: last entry per person Chris Travers (08:30)
• Re: last entry per person Andreas Kretschmer (08:40)
• Re: last entry per person Philip Couling (08:48)
• Re: last entry per person garry (08:51)
• Re: What is the best way to force character data to upper case Chris Travers (12:57)
• Re: What is the best way to force character data to upper case Raymond O'Donnell (12:59)
• Re: Extensions btree_gist and cube collide? Jay Levitt (14:58)
• Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue Adrian Klaver (16:15)
• multiple parameters to an AGGREGATE function Graham (17:27)
• Re: multiple parameters to an AGGREGATE function Merlin Moncure (17:49)
• Re: restart server on Lion John R Pierce (18:18)
• Re: Puzzling full database lock Christopher Opena (20:55)
• Warning: you don't own a lock of type ExclusiveLock Gary Chambers (21:27)

2012-02-04

• Re: Don't Thread On Me (PostgreSQL related) Rodrigo E. De León Plicet (01:53)
• Re: Warning: you don't own a lock of type ExclusiveLock Chris Angelico (02:19)
• Re: Puzzling full database lock Tom Lane (06:00)
• debugging the server[ module causes server cash] Dave Potts (07:37)
• Re: debugging the server[ module causes server cash] John R Pierce (07:49)
• Why this regexp matches?! hubert depesz lubaczewski (08:46)
• Re: Why this regexp matches?! Szymon Guz (08:54)
• Re: Why this regexp matches?! hubert depesz lubaczewski (08:58)
• Re: debugging the server[ module causes server cash] mike@trausch.us (14:33)
• Re: Why this regexp matches?! David Johnston (16:28)
• Re: debugging the server[ module causes server cash] Tom Lane (17:58)
• Re: Why this regexp matches?! Alban Hertroys (18:31)
• Re: Why this regexp matches?! hubert depesz lubaczewski (19:58)
• Re: Why this regexp matches?! Tom Lane (20:27)
• Re: Why this regexp matches?! hubert depesz lubaczewski (22:47)

2012-02-05

• Your partner Edwin needs your help! Edwin Quijada (04:45)
• Error while importing CSV file Shadin_ (16:04)
• Re: Error while importing CSV file David Johnston (16:25)
• vacuumlo fails pgsql ver 8.3 Pat Heuvel (17:24)
• Re: vacuumlo fails pgsql ver 8.3 Tom Lane (17:39)
• Large object rights management Giuseppe Sacco (22:30)
• .psql_history file is messed up and control-r does not work zhong ming wu (23:32)

2012-02-06

• Re: .psql_history file is messed up and control-r does not work Tom Lane (00:05)
• Re: .psql_history file is messed up and control-r does not work zhong ming wu (00:40)
• sql query bug??? Scott Ribe (02:03)
• SPI functions to work with the Execution Plan Osmel Barreras Piñera (03:01)
• Re: Error while importing CSV file Lockas (05:06)
• Re: Error while importing CSV file Lockas (05:14)
• Re: Error while importing CSV file dhaval jaiswal (05:20)
• Re: sql query bug??? Tom Lane (05:46)
• Re: SPI functions to work with the Execution Plan Tom Lane (05:48)
• Triggering a function on table overwrite Bob Pawley (05:56)
• Re: Error while importing CSV file Lockas (06:07)
• Re: sql query bug??? Scott Ribe (06:07)
• Re: Error while importing CSV file Lockas (06:37)
• Re: Triggering a function on table overwrite Misa Simic (09:35)
• Re: Triggering a function on table overwrite Thomas Kellerer (09:42)
• Re: Triggering a function on table overwrite Chris Angelico (09:50)
• Re: Triggering a function on table overwrite Misa Simic (10:40)
• Re: Why extract( ... from timestamp ) is not immutable? Jasen Betts (11:13)
• Re: Why extract( ... from timestamp ) is not immutable? Jasen Betts (11:14)
• Re: Error while importing CSV file Alban Hertroys (11:23)
• Re: Why this regexp matches?! Jasen Betts (11:29)
• Re: Why this regexp matches?! hubert depesz lubaczewski (11:48)
• Re: vacuumlo fails pgsql ver 8.3 Pat Heuvel (12:18)
• Re: Error while importing CSV file Lockas (12:26)
• Re: Error while importing CSV file David Johnston (12:32)
• Re: Error while importing CSV file Alban Hertroys (12:34)
• Backup database remotely Fanbin Meng (13:52)
• Re: Puzzling full database lock Merlin Moncure (14:34)
• How to create crosstab with 3 values in every crosstab column Andrus (15:23)
• Re: How to create crosstab with 3 values in every crosstab column Misa Simic (16:01)
• windows 2008 scheduled task problem Ralph Dell (16:26)
• Re: How to create crosstab with 3 values in every crosstab column Andrus (16:29)
• Re: windows 2008 scheduled task problem Susan Cassidy (16:42)
• Re: vacuumlo fails pgsql ver 8.3 Tom Lane (16:48)
• Re: windows 2008 scheduled task problem Richard Sickler (17:03)
• Re: [GENERAL] pg_dump -s dumps data?! Andrew Dunstan (17:18)
• Re: Backup database remotely Andreas Kretschmer (17:28)
• Re: How to create crosstab with 3 values in every crosstab column Misa Simic (17:38)
• Re: Save and load jpg in a PostgreSQL database bonave (17:53)
• Re: How to create crosstab with 3 values in every crosstab column Andrus (18:01)
• Re: How to create crosstab with 3 values in every crosstab column Misa Simic (18:51)
• SSL mode detection Bosco Rama (19:14)
• Re: How to create crosstab with 3 values in every crosstab column Marc Mamin (19:59)
• Re: windows 2008 scheduled task problem Ralph Dell (20:03)
• Re: windows 2008 scheduled task problem - Solved Ralph Dell (20:23)
• SOUNDEX call 84.le0n (21:48)
• pg_upgrade: out of memory deepak (22:14)
• problems connecting to php via pg_connect and PGCLUSTER Dave Potts (23:03)
• Re: problems connecting to php via pg_connect and PGCLUSTER Chris (23:38)

2012-02-07

• Re: \copy: unexpected response (4) Charlie (00:01)
• Re: Don't Thread On Me (PostgreSQL related) John R Pierce (05:05)
• Re: Error while importing CSV file Lockas (05:43)
• Re: Don't Thread On Me (PostgreSQL related) Chris Travers (05:55)
• Re: problems connecting to php via pg_connect and PGCLUSTER Dave Potts (06:08)
• default database selector Dave Potts (06:31)
• Re: Don't Thread On Me (PostgreSQL related) Achilleas Mantzios (08:30)
• Re: Error while importing CSV file Alban Hertroys (09:43)
• Postgres Table level statement logging Madhu S R (10:42)
• problems sending email to list mgould (13:28)
• Re: problems sending email to list Maton, Brett (13:33)
• How to write in Postgres mgould (14:03)
• Re: How to write in Postgres Alban Hertroys (14:45)
• Re: default database selector Adrian Klaver (14:49)
• Re: Error while importing CSV file Adrian Klaver (14:53)
• Re: How to write in Postgres Merlin Moncure (15:06)
• Re: Postgres Table level statement logging Vibhor Kumar (17:15)
• Re: Postgres Table level statement logging Andreas Kretschmer (17:21)
• Re: [GENERAL] pg_dump -s dumps data?! Tom Lane (19:56)
• Re: SOUNDEX call Marti Raudsepp (20:47)
• Re: [GENERAL] pg_dump -s dumps data?! Andrew Dunstan (22:00)
• Re: problems connecting to php via pg_connect and PGCLUSTER Chris (22:35)
• Re: problems connecting to php via pg_connect and PGCLUSTER Scott Marlowe (22:43)

2012-02-08

• Hi,are there any other open source parallel query engine like pgpool? sunpeng (04:19)
• Re: Hi,are there any other open source parallel query engine like pgpool? Pavel Stehule (06:07)
• [FIXED] Re: problems connecting to php via pg_connect and PGCLUSTER Dave Potts (06:30)
• Re: vacuumlo fails pgsql ver 8.3 Pat Heuvel (09:48)
• Re: SOUNDEX call 84.le0n (13:37)
• easy function or trigger to UPPER() all alpha data mgould (15:55)
• Defining Role Privileges Carlos Mennens (16:19)
• Re: easy function or trigger to UPPER() all alpha data Andreas Kretschmer (16:51)
• Re: Defining Role Privileges Tom Lane (16:56)
• Re: easy function or trigger to UPPER() all alpha data Andreas Kretschmer (17:13)
• Re: [GENERAL] pg_dump -s dumps data?! Tom Lane (20:31)
• Re: Don't Thread On Me (PostgreSQL related) Vincent Veyron (22:40)

2012-02-09

• phantom long-running query (check_postgres.pl reports a long-running query, but the database logs don't show it) Aleksey Tsalolikhin (00:32)
• What is this vacuum doing? Joseph Shraibman (08:46)
• Re: phantom long-running query (check_postgres.pl reports a long-running query, but the database logs don't show it) Achilleas Mantzios (08:57)
• VIEW still referring to old name of field Robins Tharakan (13:46)
• Re: SOUNDEX call Marti Raudsepp (14:00)
• Re: Warning: you don't own a lock of type ExclusiveLock Gary Chambers (15:35)
• Re: VIEW still referring to old name of field Tom Lane (15:41)
• Re: Warning: you don't own a lock of type ExclusiveLock Chris Angelico (15:59)
• Strategy for Primary Key Generation When Populating Table Rich Shepard (16:49)
• Re: Strategy for Primary Key Generation When Populating Table Merlin Moncure (17:01)
• Re: Strategy for Primary Key Generation When Populating Table Rich Shepard (17:08)