Mailing lists [pgsql-bugs]

1 October 2007

• 08:30   BUG #3645: regular expression back references seem broken Eric Haszlakiewicz
• 15:35   Re: BUG #3645: regular expression back references seem broken Tom Lane
• 17:15   BUG #3637: Path resolving function (feature request) Pedro Gimeno
• 17:15   Question about PostGreSQL Alejandro Fernandez Peral
• 17:34   Re: Question about PostGreSQL Heikki Linnakangas
• 19:24   Re: Question about PostGreSQL Kevin Grittner
• 19:36   Re: BUG #3645: regular expression back references seem broken Eric Haszlakiewicz

2 October 2007

• 07:12   Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field Guillaume 'ioguix' de Rorthais
• 14:05   BUG #3646: installation problem Anton
• 19:26   BUG #3647: error message logged to stderr only, not redirect logfile Michael Charnoky
• 21:20   Re: BUG #3647: error message logged to stderr only, not redirect logfile Tom Lane

3 October 2007

• 07:43   BUG #3648: Server crashes when trying to create a table Anton
• 07:47   BUG #3649: Confusing error message: ERROR: syntax error at or near "$1" Audrius Meskauskas
• 12:52   Re: BUG #3648: Server crashes when trying to create a table Alvaro Herrera
• 17:27   Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field Heikki Linnakangas
• 17:34   Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field Tom Lane

4 October 2007

• 01:00   Re: BUG #3648: Server crashes when trying to create a table Anton A. Patrushev
• 01:06   Re: BUG #3648: Server crashes when trying to create a table Anton A. Patrushev
• 02:42   Re: BUG #3648: Server crashes when trying to create a table Alvaro Herrera
• 04:11   Re: BUG #3648: Server crashes when trying to create a table Anton A. Patrushev
• 16:22   Re: BUG #3484: Missing pg_clog file / corrupt index Marc Schablewski
• 16:37   BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message Robert Kleemann
• 18:26   Re: BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message Tom Lane
• 19:32   Re: BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message Robert Kleemann
• 19:32   BUG #3653: Database crash Marc Munro
• 21:14   Re: BUG #3653: Database crash Tom Lane

5 October 2007

• 07:20   BUG #3654: Inconsistent handling of usernames Radim Kolar
• 07:24   BUG #3655: Inconsistent handling of usernames Radim Kolar
• 08:00   BUG #3656: cannot truncate table in PGSQL from Java Eli
• 10:02   Re: BUG #3654: Inconsistent handling of usernames tomas@tuxteam.de
• 15:15   BUG #3657: Performance leaks when using between of two equal dates Tiago Daniel Jacobs

6 October 2007

• 16:05   Re: BUG #3657: Performance leaks when using between of two equal dates Alvaro Herrera
• 16:28   Re: BUG #3657: Performance leaks when using between of two equal dates Tom Lane
• 17:34   Re: BUG #3657: Performance leaks when using between of two equal dates Tiago Daniel Jacobs

8 October 2007

• 09:45   BUG #3658: I've got disk-full errors when insert relational tables. Alessandra Bilardi
• 15:20   BUG #3659: should use implizit type cast in check constraint Michael Enke
• 15:55   Re: BUG #3657: Performance leaks when using between of two equal dates Kevin Grittner
• 15:57   Re: BUG #3659: should use implizit type cast in check constraint Tom Lane
• 18:01   Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field Bruce Momjian
• 20:01   Re: BUG #3657: Performance leaks when using between of two equal dates Tiago Daniel Jacobs

9 October 2007

• 11:53   BUG #3660: unused empty file is created with csvlog Thomas Reiss
• 13:18   Re: BUG #3660: unused empty file is created with csvlog Tom Lane
• 13:56   Provide a way to not ask for a password in psql Martin Pitt
• 14:32   libpq crash fix [was: Provide a way to not ask for a password in psql] Martin Pitt
• 15:04   Re: libpq crash fix [was: Provide a way to not ask for a password in psql] Magnus Hagander
• 15:33   plpythonu execute - create function bug? blay bloo
• 15:53   BUG #3661: Missing equality comparator: string = integer David Bachmann
• 15:53   BUG #3662: Seems that more than one run of a functions causes an error Robins Tharakan
• 16:09   BUG #3663: Installer: Encoding(Server) Select list have not UTF-8 encoding. Kevin.Lee
• 16:54   Re: BUG #3663: Installer: Encoding(Server) Select list have not UTF-8 encoding. Hiroshi Saito
• 17:06   Re: BUG #3661: Missing equality comparator: string = integer Peter Eisentraut
• 17:15   Re: BUG #3661: Missing equality comparator: string = integer Pavel Stehule
• 18:11   Fwd: BUG #3662: Seems that more than one run of a functions causes an error Robins
• 19:12   Re: BUG #3663: Installer: Encoding(Server) Select list have not UTF-8 encoding. Magnus Hagander
• 20:49   BUG #3664: CANNOT LOAD FROM FILE Maciej Szarlinski
• 23:24   Re: plpythonu execute - create function bug? Tom Lane

10 October 2007

• 01:38   Re: Provide a way to not ask for a password in psql Euler Taveira de Oliveira
• 07:08   Re: Provide a way to not ask for a password in psql Peter Eisentraut
• 09:51   PQmakeEmptyPQresult makes my application dumps core? Adam PAPAI
• 11:49   Re: PQmakeEmptyPQresult makes my application dumps core? Tom Lane
• 11:51   Re: PQmakeEmptyPQresult makes my application dumps core? Gregory Stark
• 13:03   BUG #3665: INSERT is not allowed in a non-volatile function Evgeni
• 13:55   BUG #3666: Truncated Parameter in LDAP string when spaces contained Yves
• 13:58   Re: BUG #3665: INSERT is not allowed in a non-volatile function Tom Lane
• 17:10   Re: PQmakeEmptyPQresult makes my application dumps core? Gregory Stark
• 18:18   BUG #3667: Job scheduling with Greenplum fails Jon Roberts
• 19:57   Re: BUG #3667: Job scheduling with Greenplum fails Tom Lane
• 20:06   BUG #3668: type error in serial Eric Weimer
• 21:23   Re: BUG #3667: Job scheduling with Greenplum fails Tom Lane
• 21:32   Re: BUG #3668: type error in serial Tom Lane
• 21:37   Re: BUG #3667: Job scheduling with Greenplum fails Roberts, Jon

11 October 2007

• 00:01   Re: BUG #3662: Seems that more than one run of a functions causes an error Tom Lane
• 00:12   Re: BUG #3662: Seems that more than one run of a functions causes an error Tom Lane
• 07:16   BUG #3669: cann't use UTF8 as server side encoding huanghongdong
• 10:52   Re: BUG #3669: cann't use UTF8 as server side encoding Hiroshi Saito
• 12:00   BUG #3670: Exception thrown when attempting to debug Ognjen Babic
• 12:56   Re: BUG #3667: Job scheduling with Greenplum fails Roberts, Jon
• 15:14   Re: BUG #3667: Job scheduling with Greenplum fails Andrew Sullivan
• 15:14   BUG #3671: if locale=french, service idles at 100% CPU Nathanael TERRIEN
• 15:57   Re: BUG #3667: Job scheduling with Greenplum fails Roberts, Jon
• 22:06   Deferred FK / PK deletion problems Greg Sabino Mullane
• 22:18   Re: Deferred FK / PK deletion problems Tom Lane

12 October 2007

• 06:17   expression_tree_walker() and primitive node types Neil Conway
• 08:35   Win XP(SP2) install error KODAMA, Toshihito
• 10:24   Re: Win XP(SP2) install error Magnus Hagander
• 12:54   BUG #3672: ALTER TYPE change the underlying index tablespace to default Marc Mamin
• 13:18   BUG #3673: Untrusted perl language: ERROR: could not open relation 1663/16384/1259: No such file or directory Timur Luchkin
• 13:36   Re: BUG #3673: Untrusted perl language: ERROR: could not open relation 1663/16384/1259: No such file or directory Heikki Linnakangas
• 14:23   Re: expression_tree_walker() and primitive node types Tom Lane
• 14:33   libpq5 8.3 breaks 8.2 compatibility with encodings Martin Pitt
• 14:56   BUG #3674: Unnecessary checkpoints by WAL Writer ITAGAKI Takahiro
• 15:14   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Martin Pitt
• 15:51   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane
• 16:02   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane
• 16:19   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Martin Pitt
• 16:20   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Peter Eisentraut
• 16:54   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane
• 17:03   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Heikki Linnakangas
• 17:07   Re: BUG #3674: Unnecessary checkpoints by WAL Writer Tom Lane
• 17:08   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Martin Pitt
• 17:11   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Heikki Linnakangas
• 17:23   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane
• 17:38   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Martin Pitt
• 17:54   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane
• 21:47   Re: libpq5 8.3 breaks 8.2 compatibility with encodings Tom Lane

13 October 2007

• 02:07   Re: BUG #3672: ALTER TYPE change the underlying index tablespace to default Tom Lane
• 16:56   BUG #3676: README.TXT is duff gen Rolf de By
• 16:56   BUG #3675: Crash on xpath function with 2 parameters Jeremy Palmer
• 17:29   Re: BUG #3675: Crash on xpath function with 2 parameters Kris Jurka
• 20:50   Re: BUG #3675: Crash on xpath function with 2 parameters Tom Lane

15 October 2007

• 07:27   pg_dump and password required Sergey Litvinenko
• 07:35   Re: pg_dump and password required Devrim GÜNDÜZ
• 08:25   Re: BUG #3676: README.TXT is duff gen Dave Page
• 13:33   BUG #3677: ceil/floor not working as expected Aleksander Machniak
• 14:01   Re: BUG #3677: ceil/floor not working as expected Heikki Linnakangas
• 14:02   BUG #3678: Folder Windows Don't Open Properly Doug Bedell
• 16:02   IPv6 Support in 8.0.3 Kevin Kuhner
• 16:27   Re: IPv6 Support in 8.0.3 Stefan Kaltenbrunner
• 20:43   Re: BUG #3674: Unnecessary checkpoints by WAL Writer Simon Riggs
• 20:43   Re: BUG #3667: Job scheduling with Greenplum fails Simon Riggs
• 21:53   Re: BUG #3667: Job scheduling with Greenplum fails Dave Page
• 22:11   Re: Deferred FK / PK deletion problems Greg Sabino Mullane
• 22:53   Re: BUG #3667: Job scheduling with Greenplum fails Simon Riggs

16 October 2007

• 08:45   Re: BUG #3667: Job scheduling with Greenplum fails Dave Page
• 13:46   BUG #3679: need windows version thobiyas
• 20:45   BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" ssurui
• 21:19   Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" Douglas Toltzman
• 21:23   Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" Kevin Grittner

17 October 2007

• 07:56   Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" ssurui
• 08:10   BUG #3681: fillers are NULL in pgbench ITAGAKI Takahiro
• 15:47   Re: BUG #3681: fillers are NULL in pgbench Tom Lane
• 17:35   Re: BUG #3680: memory leak when excuting a SQL "select count(id) from chinatelecom;" Kevin Grittner

18 October 2007

• 01:04   Re: BUG #3680: memory leak when excuting a SQL "selectcount(id) from chinatelecom;" ssurui
• 01:18   Re: BUG #3680: memory leak when excuting a SQL "selectcount(id) from chinatelecom;" Douglas Toltzman
• 03:20   Re: BUG #3681: fillers are NULL in pgbench ITAGAKI Takahiro
• 13:20   Re: 'on insert do instead' rule with a where clause responds 'INSERT 0 0' Julius Stroffek
• 20:10   creating a table with a serial column sets currval Kris Jurka
• 20:24   Re: creating a table with a serial column sets currval Kris Jurka
• 20:48   Re: creating a table with a serial column sets currval Tom Lane
• 21:04   Re: [JDBC] Re: 'on insert do instead' rule with a where clause responds 'INSERT 0 0' Oliver Jowett
• 23:25   Re: creating a table with a serial column sets currval Kris Jurka

19 October 2007

• 07:25   Fwd: Stalled post to pgsql-bugs Ciprian Dorin Craciun
• 13:24   Re: creating a table with a serial column sets currval Tom Lane
• 13:37   PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Dawid Kuroczko
• 14:07   Re: PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Heikki Linnakangas
• 14:31   Re: PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Tom Lane
• 22:48   Re: PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Dawid Kuroczko

20 October 2007

• 03:05   Re: PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Tom Lane
• 07:52   BUG #3682: Incomplete database restore Gary Chambers
• 08:44   Re: BUG #3682: Incomplete database restore Heikki Linnakangas
• 09:37   BUG #3684: After dump/restore, schema PUBLIC always exists Pedro Gimeno
• 14:37   Re: BUG #3682: Incomplete database restore Heikki Linnakangas

21 October 2007

• 13:25   BUG #3685: PgAdmin crashes at startup Pavel Velikhov
• 13:28   BUG #3686: Incorrect numeric type conversion to long in plpythonu Sergi
• 13:28   Re: PostgreSQL 8.2 Bug in casting varchar to int in SELECT ... WHERE IN ( ... ) Dawid Kuroczko
• 18:42   BUG #3687: PL/Python is built against Python 2.4 Stavros Korokithakis
• 18:57   Re: BUG #3682: Incomplete database restore Heikki Linnakangas
• 20:24   Re: BUG #3682: Incomplete database restore Tom Lane
• 23:15   Re: BUG #3686: Incorrect numeric type conversion to long in plpythonu Tom Lane

22 October 2007

• 07:26   Re: BUG #3682: Incomplete database restore Gary Chambers
• 07:30   Re: BUG #3682: Incomplete database restore Magnus Hagander
• 09:33   Re: BUG #3682: Incomplete database restore Heikki Linnakangas
• 14:13   Cursor on an INTERSECT query assertion fails Heikki Linnakangas
• 14:40   Re: BUG #3682: Incomplete database restore Tom Lane
• 14:59   BUG #3691: bug in pg_restore Maryz
• 15:05   Re: BUG #3691: bug in pg_restore Heikki Linnakangas
• 15:33   Re: BUG #3691: bug in pg_restore Heikki Linnakangas
• 16:51   Re: BUG #3691: bug in pg_restore Tom Lane
• 17:06   Re: Cursor on an INTERSECT query assertion fails Tom Lane
• 21:22   BUG #3692: Conflicting create table statements throw unexpected error Bill Moran
• 21:45   Re: BUG #3692: Conflicting create table statements throw unexpected error Tom Lane

23 October 2007

• 12:26   Re: BUG #3692: Conflicting create table statements throw unexpected error Bill Moran
• 13:06   Re: BUG #3692: Conflicting create table statements throw unexpected error Alvaro Herrera

24 October 2007

• 09:23   Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 12:47   Re: BUG #3692: Conflicting create table statements throw unexpected error Bill Moran
• 13:27   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 13:48   Re: Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 14:01   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 16:25   BUG #3693: PSQLException when using ResultSet.getLong(String) in turkish locale Dirk Moebius
• 16:51   Re: Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 20:57   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane

25 October 2007

• 08:24   BUG #3695: Pgsql does not report non existing function Roger
• 12:46   Yet another problem with ILIKE and UTF-8 Gergely Bor
• 14:12   BUG #3696: FK integrity check bypassed using rules. Pierre-yves Strub
• 14:18   Re: Yet another problem with ILIKE and UTF-8 Gregory Stark
• 14:37   Re: BUG #3695: Pgsql does not report non existing function Tom Lane
• 14:51   BUG #3697: utf8 issue: can not reimport a table that was successfully exported. Marc Mamin
• 15:17   Re: Yet another problem with ILIKE and UTF-8 Gergely Bor
• 16:12   Re: BUG #3697: utf8 issue: can not reimport a table that was successfully exported. Tom Lane
• 16:29   Re: BUG #3696: FK integrity check bypassed using rules. Tom Lane
• 16:33   Re: Yet another problem with ILIKE and UTF-8 Gregory Stark
• 16:35   Re: Yet another problem with ILIKE and UTF-8 Tom Lane
• 16:39   Re: BUG #3697: utf8 issue: can not reimport a table that was successfully exported. Tom Lane
• 17:02   Re: BUG #3696: FK integrity check bypassed using rules. Pierre-Yves Strub
• 17:55   Re: BUG #3697: utf8 issue: can not reimport a table that was successfully exported. Marc Mamin
• 22:00   PostgreSQL crash on Freebsd 7 Michael
• 23:40   Re: PostgreSQL crash on Freebsd 7 Alvaro Herrera

26 October 2007

• 00:16   Re: PostgreSQL crash on Freebsd 7 Tom Lane
• 00:45   Re: PostgreSQL crash on Freebsd 7 Michael
• 01:11   Re: PostgreSQL crash on Freebsd 7 Tom Lane
• 01:29   Re: PostgreSQL crash on Freebsd 7 Michael
• 07:34   BUG #3699: Fails to compile DTrace Support Lee Packham
• 08:43   BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250" Marek Romanowski
• 08:52   Re: BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250" Magnus Hagander
• 08:53   Re: BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250" Dave Page
• 12:50   connection problem annaiah h
• 13:15   Re: connection problem Tom Lane
• 13:43   Re: BUG #3699: Fails to compile DTrace Support Tom Lane
• 13:59   Re: Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 14:13   Re: BUG #3699: Fails to compile DTrace Support Robert Lor
• 14:18   The PostgreSQL Data directory Must be on an NTFS formatted Volume larm@mailme.dk
• 14:19   Re: BUG #3699: Fails to compile DTrace Support Lee Packham
• 14:19   Re: Yet another problem with ILIKE and UTF-8 Gergely Bor
• 14:29   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 14:32   Re: BUG #3699: Fails to compile DTrace Support Tom Lane
• 14:55   Re: BUG #3699: Fails to compile DTrace Support Robert Lor
• 15:07   Re: The PostgreSQL Data directory Must be on an NTFS formatted Volume David Fetter
• 18:15   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 18:37   BUG #3701: Don't work intarray GIN indexes girla
• 19:07   Re: The PostgreSQL Data directory Must be on an NTFS formatted Volume Chris Browne
• 19:43   Re: BUG #3701: Don't work intarray GIN indexes Tom Lane

28 October 2007

• 13:00   Re: BUG #3362: xlog corruption just after initdb on irix Herve Boulouis
• 22:34   Re: BUG #3362: xlog corruption just after initdb on irix Tom Lane

29 October 2007

• 15:28   Re: Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 15:45   BUG #3706: ecpg regression: "MOVE FORWARD" Scott Bailey
• 16:13   Re: Possible planner bug/regression introduced in 8.2.5 Greg Sabino Mullane
• 18:18   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 18:35   Re: Possible planner bug/regression introduced in 8.2.5 Jakub Ouhrabka
• 19:02   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 20:07   BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue Rene Gollent
• 20:50   Re: BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue Tom Lane

30 October 2007

• 04:09   Re: Possible planner bug/regression introduced in 8.2.5 Tom Lane
• 08:29   BUG #3708: Ongoing transactin that involves the table containing foreign key blocks updates of referenced table Maksym Sobolyev
• 08:30   BUG #3709: Changing Table Owner Vishesh Jain
• 11:26   Re: BUG #3709: Changing Table Owner Moiz Kothari
• 19:20   Fw: BUG #3695: Pgsql does not report non existing function Roger Moloney

31 October 2007

• 08:42   I incrementally altered my database into a state where backups couldn't be restored. Adam Tomjack
• 10:06   Re: I incrementally altered my database into a state where backups couldn't be restored. Heikki Linnakangas
• 11:33   Re: I incrementally altered my database into a state where backups couldn't be restored. Gregory Stark
• 13:31   Re: I incrementally altered my database into a state where backups couldn't be restored. Tom Lane
• 13:43   Re: I incrementally altered my database into a state where backups couldn't be restored. Gregory Stark
• 14:38   Re: I incrementally altered my database into a state where backups couldn't be restored. Heikki Linnakangas
• 20:07   Re: I incrementally altered my database into a state where backups couldn't be restored. Adam Tomjack
• 21:17   BUG #3711: dropdb and creatdb with pgpass.conf file gregory vallet
• 22:37   Re: BUG #3711: dropdb and creatdb with pgpass.conf file Heikki Linnakangas
• 22:44   Re: BUG #3711: dropdb and creatdb with pgpass.conf file Tom Lane