Peripheral Links

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

pgsql-general - July 2009

2009-07-01

• Re: Postgres online backup and restore Scott Mead (00:05)
• Re: Postgres online backup and restore Scott Mead (00:35)
• Re: [Fwd: Re: Python client + select = locked resources???] Craig Ringer (07:43)
• Re: Python client + select = locked resources??? Scott Marlowe (07:49)
• Re: High consumns memory Albe Laurenz (08:08)
• Multi - table statistics Scara Maccai (09:15)
• cache reads vs. disk reads Gerd König (09:20)
• Re: Regex Character-Class Henry (09:29)
• Big Delete Consistently Causes a Crash Tony Webb (11:24)
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function Chris Spotts (11:32)
• Re: [Fwd: Re: Python client + select = locked resources???] durumdara (12:33)
• Re: WAL and master multi-slave replication Scot Kreienkamp (13:24)
• Re: Big Delete Consistently Causes a Crash Tom Lane (13:56)
• Re: FW: lack in psql console Juan Camilo Marín (15:57)
• Re: Python client + select = locked resources??? johnf (16:21)
• Re: Python client + select = locked resources??? Scott Mead (16:34)
• Preventing a user to use implicit casts Stéphane A. Schildknecht (17:57)
• Re: Preventing a user to use implicit casts Scott Marlowe (18:05)
• Re: Preventing a user to use implicit casts Stéphane A. Schildknecht (18:11)
• Re: Preventing a user to use implicit casts Pavel Stehule (18:43)
• Re: High consumns memory Merlin Moncure (21:00)
• Does anyone know of a job scheduler that uses PostgreSQL? Anthony Caduto (21:16)
• Re: Python client + select = locked resources??? Erik Jones (21:31)
• Re: Preventing a user to use implicit casts Scott Marlowe (21:44)
• Re: datestyle no effect in 8.3.7 Bruce Momjian (22:38)

2009-07-02

• 1 Sequence per Row i.e. each customer's first order starts at 1 Merrick (00:04)
• Problem search on text arrays, using the overlaps (&&) operator John Cheng (00:07)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Greg Stark (00:32)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Scott Marlowe (01:01)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Merrick (01:46)
• Re: Bug in ecpg lib ? leif (01:52)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Scott Marlowe (02:10)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Scott Marlowe (02:12)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Merrick (03:11)
• R: Does anyone know of a job scheduler that uses PostgreSQL? Scara Maccai (05:57)
• Re: Help with installation please... Craig Ringer (07:02)
• The connection closed unexpectedly - C++ and Postgre drestajumena (08:05)
• Re: The connection closed unexpectedly - C++ and Postgre Scott Marlowe (08:28)
• Re: The connection closed unexpectedly - C++ and Postgre drestajumena (09:28)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Greg Stark (09:28)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Scott Marlowe (09:35)
• An example needed for Serializable conflict... Durumdara (09:52)
• Delete triggers order in delete cascade (pg 8.3.7). Michaël Lemaire (09:56)
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1 Greg Stark (11:27)
• Re: Delete triggers order in delete cascade (pg 8.3.7). Richard Huxton (12:14)
• Re: Does anyone know of a job scheduler that uses PostgreSQL? Reid Thompson (12:42)
• Re: Delete triggers order in delete cascade (pg 8.3.7). Michaël Lemaire (13:01)
• Re: Delete triggers order in delete cascade (pg 8.3.7). Richard Huxton (13:32)
• Fwd: High consumns memory Anderson Valadares (14:18)
• Fwd: High consumns memory Anderson Valadares (14:19)
• Re: Delete triggers order in delete cascade (pg 8.3.7). Michaël Lemaire (14:27)
• No password prompt logging into Postgres 8.4 Ben Trewern (14:37)
• Upgrading 8.3 to 8.4 on Windows. Hartman, Matthew (14:46)
• Re: Replication Simon Riggs (14:50)
• Re: No password prompt logging into Postgres 8.4 Bill Moran (14:57)
• Re: Upgrading 8.3 to 8.4 on Windows. Richard Huxton (14:59)
• Re: Database schema dumper Joshua J. Kugler (15:11)
• compiling postgres for 64 bit windows using mingw64 McWilliams, Steven (16:22)
• Re: Replication and coding good practices Simon Riggs (16:33)
• Re: pgAdmin - no_spool Simon Riggs (16:36)
• Re: compiling postgres for 64 bit windows using mingw64 Tom Lane (16:49)
• PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors James B. Byrne (16:56)
• simulate multiple primary keys Brandon Metcalf (17:27)
• Re: simulate multiple primary keys Hartman, Matthew (17:29)
• Re: pgAdmin - no_spool Pedro Doria Meunier (17:30)
• Re: simulate multiple primary keys Brandon Metcalf (17:37)
• Re: simulate multiple primary keys Bill Moran (17:40)
• Re: simulate multiple primary keysx Brandon Metcalf (17:55)
• Re: pgAdmin - no_spool Simon Riggs (18:03)
• Q: data modeling with inheritance Reece Hart (20:54)
• Re: simulate multiple primary keys Lennin Caro (21:31)

2009-07-03

• Re: Q: data modeling with inheritance Nathan Boley (02:19)
• Installing plpython on 8.4 Scott Bailey (03:09)
• Re: Installing plpython on 8.4 Peter Eisentraut (08:37)
• Re: Problem search on text arrays, using the overlaps (&&) operator Andreas Wenk (09:12)
• Howto get the contents of mystopwords/dictionary/synonym/thesaurus ? Joost Kraaijeveld (09:18)
• Group by on %like% Jennifer Trey (09:44)
• Group by on %like% Serge Fonville (09:51)
• Re: Vacation reply Serge Fonville (09:58)
• Re: Group by on %like% Guy Flaherty (10:32)
• Re: Group by on %like% Guy Flaherty (10:37)
• How to use RETURN TABLE in Postgres 8.4 Michal Szymanski (10:52)
• Re: Group by on %like% Dimitri Fontaine (10:53)
• Re: [GENERAL] Vacation reply Bruce Momjian (13:36)
• Re: [GENERAL] Vacation reply Serge Fonville (13:43)
• Re: Delete triggers order in delete cascade (pg 8.3.7). Jasen Betts (13:47)
• REINDEX "is not a btree" Vanessa Lopez (14:00)
• Re: [GENERAL] Vacation reply Greg Sabino Mullane (14:10)
• unsubscribe-pattern-allmatching LISTNAME ALL Raul Rojas (14:26)
• Re: Problem search on text arrays, using the overlaps (&&) operator John Cheng (14:37)
• Re: How to use RETURN TABLE in Postgres 8.4 Tom Lane (15:46)
• Re: How to use RETURN TABLE in Postgres 8.4 Pavel Stehule (15:49)
• Re: Group by on %like% nha (16:37)
• Re: How to use RETURN TABLE in Postgres 8.4 Michael Black (17:06)
• Store derived data or use view? gvimrc (17:08)
• Re: Store derived data or use view? Hartman, Matthew (17:46)
• Re: Q: data modeling with inheritance David Fetter (18:29)
• Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ? ANdreas Wenk (19:24)
• Re: Store derived data or use view? Martin Gainty (19:46)
• Re: PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors ANdreas Wenk (20:05)
• Re: Store derived data or use view? Michael Black (22:23)
• Re: Installing plpython on 8.4 Scott Bailey (23:57)

2009-07-04

• Re: Q: data modeling with inheritance Reece Hart (00:37)
• Re: Q: data modeling with inheritance Reece Hart (00:51)
• Re: Q: data modeling with inheritance David Fetter (01:23)
• Pls help Roseller A. Romanos (04:02)
• Re: Pls help Pavel Stehule (04:40)
• Re: Pls help Scott Marlowe (06:03)
• Re: Pls help Pavel Stehule (06:12)
• Re: Pls help Scott Marlowe (06:13)
• Re: Pls help Pavel Stehule (06:22)
• Re: Pls help Scott Marlowe (06:27)
• Re: Pls help Scott Marlowe (06:27)
• Start automatically a function at startup of postgresql server dfx@dfx.it (08:51)
• Re: Group by on %like% Jennifer Trey (09:44)
• Re: REINDEX "is not a btree" Craig Ringer (13:06)
• about pg_stat_get_db_xact_commit abdelhak benmohamed (13:55)
• Re: Start automatically a function at startup of postgresql server Gurjeet Singh (16:43)
• Re: Installing plpython on 8.4 Peter Eisentraut (16:50)
• Function Issue and casting Juan Pablo Cook (17:47)
• Re: Function Issue and casting Adrian Klaver (18:25)
• Function Issue and casting Juan Pablo Cook (19:12)
• Documentation - PgAdmin db.subscriptions (20:27)
• Will there be an official pg_migrator release? Thomas Kellerer (21:03)
• Re: Pls help justin (22:49)
• Re: Documentation - PgAdmin justin (22:58)

2009-07-05

• Re: Will there be an official pg_migrator release? Bruce Momjian (00:13)
• multiple rows by date using count(*) Shad Keene (03:20)
• Re: Documentation - PgAdmin Raymond O'Donnell (08:41)
• Re: multiple rows by date using count(*) Andreas Kretschmer (09:25)
• Re: multiple rows by date using count(*) Alban Hertroys (09:26)
• Postgres Plus Advanced Server and general Postgres compatibility? Andre Lopes (11:19)
• Example of full text search ranking function somewhere? Joost Kraaijeveld (12:12)
• Re: How to use RETURN TABLE in Postgres 8.4 Michal Szymanski (13:51)
• Re: Will there be an official pg_migrator release? Thomas Kellerer (15:32)
• Re: Documentation - PgAdmin Justin Graf (17:14)
• Re: Documentation - PgAdmin Raymond O'Donnell (17:39)
• Re: Documentation - PgAdmin Sachin Srivastava (18:22)
• Re: Documentation - PgAdmin Guillaume Lelarge (20:00)

2009-07-06

• GISVM Server pre-release available Ricardo Pinho (00:49)
• COALESCE not filtering well. Mohan Raj B (05:37)
• LIKE problem Juan Pablo Cook (05:55)
• Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index CM J (05:58)
• Re: LIKE problem Pavel Stehule (06:15)
• Re: LIKE problem A. Kretschmer (06:19)
• Re: [GENERAL] Documentation - PgAdmin Guillaume Lelarge (06:57)
• howto determine rows count to be returned by DECLARE ... SELECT ... Konstantin Izmailov (07:21)
• Re: Documentation - PgAdmin Dave Page (07:33)
• Passing a table to function sqlguru (11:27)
• Normalize INTERVAL ouput format in a db driver Sebastien FLAESCH (11:49)
• Re: Postgres Plus Advanced Server and general Postgres compatibility? Abbas (12:18)
• Re: Normalize INTERVAL ouput format in a db driver Sebastien FLAESCH (12:25)
• Re: COALESCE not filtering well. Greg Stark (12:54)
• Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index Tom Lane (14:59)
• Re: Upgrading 8.3 to 8.4 on Windows. Tguru (15:40)
• Re: Problem search on text arrays, using the overlaps (&&) operator nha (16:12)
• Feistel cipher, shorter string and hex to int Ivan Sergio Borgonovo (16:45)
• Windows installer for pg-8.4 confusion Stuart McGraw (17:06)
• Re: Windows installer for pg-8.4 confusion Andreas Wenk (17:22)
• Performance problem with low correlation data Scara Maccai (17:32)
• Re: Windows installer for pg-8.4 confusion Stuart McGraw (17:40)
• Re: Windows installer for pg-8.4 confusion Dave Page (18:21)
• Re: Performance problem with low correlation data Greg Stark (18:23)
• Added parameter for CREATE ROLE Michael Gould (18:32)
• Re: Added parameter for CREATE ROLE Raymond O'Donnell (18:40)
• Schema search_path and $user Postgres User (18:41)
• Re: Schema search_path and $user Tom Lane (19:19)
• Re: Schema search_path and $user Postgres User (19:24)
• BUG #4903: Sugestion a db modele like mysql workbrench Oscar Miguel Amezcua Estrella (19:47)
• Out of memory error Paul Smith (20:21)
• Efficiently move data from one table to another, with FK constraints? Rob W (20:22)
• Re: Windows installer for pg-8.4 confusion Bruce Momjian (20:26)
• Re: Out of memory error Tom Lane (20:34)
• Re: Out of memory error Paul Smith (20:39)
• combine multiple row values in to one row Lee Harr (21:29)
• Re: Problem search on text arrays, using the overlaps (&&) operator John Cheng (23:17)

2009-07-07

• Re: combine multiple row values in to one row Ivan Sergio Borgonovo (00:22)
• Re: Out of memory error Paul Ramsey (00:26)
• Re: Out of memory error Paul Smith (01:45)
• Re: BUG #4903: Sugestion a db modele like mysql workbrench Pavel Golub (06:17)
• Re: Performance problem with low correlation data Scara Maccai (07:16)
• Sugestion a db modele like mysql workbrench Andreas Wenk (07:33)
• Re: Normalize INTERVAL ouput format in a db driver Albe Laurenz (08:49)
• Re: Out of memory error Mark Cave-Ayland (08:59)
• Re: Feistel cipher, shorter string and hex to int Daniel Verite (09:05)
• Re: Efficiently move data from one table to another, with FK constraints? Albe Laurenz (09:12)
• Re: An example needed for Serializable conflict... Albe Laurenz (09:36)
• Re: Feistel cipher, shorter string and hex to int Daniel Verite (10:07)
• Re: An example needed for Serializable conflict... durumdara (10:10)
• Re: An example needed for Serializable conflict... Andres Freund (10:43)
• Re: Sugestion a db modele like mysql workbrench Pavel Golub (11:00)
• Re: combine multiple row values in to one row Hartman, Matthew (12:27)
• Re: Feistel cipher, shorter string and hex to int Ivan Sergio Borgonovo (12:28)
• Re: Normalize INTERVAL ouput format in a db driver Sebastien FLAESCH (13:04)
• Re: Sugestion a db modele like mysql workbrench Andreas Wenk (13:54)
• Re: Bug in ecpg lib ? Albe Laurenz (14:29)
• Table Partitioning : Having child tables in multiple database servers Ransika de Silva (14:32)
• Re: Table Partitioning : Having child tables in multiple database servers Ransika de Silva (15:38)
• Re: combine multiple row values in to one row David Fetter (15:40)
• Re: combine multiple row values in to one row David Fetter (15:43)