Mailing lists [pgsql-bugs]

1 November 2006

• 03:24   Re: COPY fails on 8.1 with invalid byte sequences in text Tom Lane

2 November 2006

• 15:11   BUG #2728: Core dump while pgdump DB Yee
• 15:11   BUG #2729: Backslash escaping not working as expected Michael van Rooyen
• 15:11   Re: documentation Maxim Britov
• 15:11   ajuda juliana martins santanna
• 15:11   BUG #2730: strange query performance ! Baudracco Pierre
• 15:11   documentation Maxim Britov
• 15:35   Re: documentation Tom Lane
• 15:58   Re: BUG #2729: Backslash escaping not working as expected Tom Lane
• 16:00   Re: BUG #2730: strange query performance ! Tom Lane
• 16:02   Re: BUG #2728: Core dump while pgdump DB Tom Lane
• 21:27   bug in timestamp and out of range values Robert Treat
• 21:48   Re: bug in timestamp and out of range values Tom Lane

3 November 2006

• 02:54   Re: bug in timestamp and out of range values Robert Treat
• 05:18   Re: bug in timestamp and out of range values Tom Lane
• 12:11   Sugestion for PostgreSQL Developer´s TEAM! Marcio
• 13:01   8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio 11 Andreas Lange
• 13:07   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio 11 Alvaro Herrera
• 13:26   Re: Sugestion for PostgreSQL Developer´s TEAM! Peter Eisentraut
• 13:33   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Andreas Lange
• 13:41   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Alvaro Herrera
• 14:16   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Tom Lane
• 14:29   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Andreas Lange
• 15:00   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Andreas Lange
• 15:12   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Tom Lane
• 15:52   BUG #2732: pg_get_serial_sequence error Basil Evseenko
• 15:52   BUG #2733: pg_get_serial_sequence error (addition: may be tsearch2 related) Basil Evseenko
• 15:52   BUG #2734: Primary Key field duplicate value Wagner Cipriano
• 15:52   BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Leonid Shlyapnikov
• 15:52   Re: [HACKERS] bug in timestamp and out of range values Joshua D. Drake
• 15:52   Re: Sugestion for PostgreSQL Developer´s Jorge Godoy
• 15:52   Re: [HACKERS] bug in timestamp and out of range values Joshua D. Drake
• 19:20   Re: COPY fails on 8.1 with invalid byte sequences in text Dennis Bjorklund
• 19:25   Re: COPY fails on 8.1 with invalid byte sequences in text Jeff Davis
• 21:16   Operator Classes and ANALYZE Rusty Conover
• 23:17   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Harald Armin Massa

4 November 2006

• 07:43   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Harald Armin Massa
• 11:57   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Harald Armin Massa
• 16:47   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Richard Troy
• 17:04   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Thomas H.
• 20:39   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Zdenek Kotala

5 November 2006

• 00:08   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Leonid Shlyapnikov
• 00:08   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Leonid Shlyapnikov
• 00:08   BUG #2735: DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs Emil J.
• 00:08   Re: BUG #2731: Cannot install PostgreSQL server on WinXP Media Center Edition Leonid Shlyapnikov
• 20:53   BUG #2737: hash indexing large table fails, while btree of same index works Balazs Nagy
• 20:53   BUG #2738: CREATE FUNCTION INSTR() in docs Michael Deichen
• 22:00   Re: BUG #2738: CREATE FUNCTION INSTR() in docs Tom Lane

6 November 2006

• 08:29   Re: BUG #2735: DEBUG: Error 2769: Custom Action GetAvailableLocales did not close 1 MSIHANDLEs Magnus Hagander
• 16:58   BUG #2740: gcc bug on intel mac with postgresql -O3 optimized build Alon Goldshuv
• 17:28   Re: BUG #2694: Memory allocation error when selecting array Tom Lane
• 17:43   BUG #2739: INTERSECT ALL not working Mason Hale
• 18:03   Re: BUG #2739: INTERSECT ALL not working Tom Lane
• 19:48   Re: BUG #2739: INTERSECT ALL not working Mason Hale
• 19:54   Re: Operator Classes and ANALYZE Simon Riggs
• 20:48   Re: Operator Classes and ANALYZE Rusty Conover
• 21:21   Re: Operator Classes and ANALYZE Simon Riggs
• 21:54   Re: Operator Classes and ANALYZE Rusty Conover
• 22:10   Re: Operator Classes and ANALYZE David Fetter
• 22:11   Re: Operator Classes and ANALYZE Simon Riggs

8 November 2006

• 00:16   Re: Sugestion for PostgreSQ Bruno Wolff III
• 10:59   Re: BUG #2712: could not fsync segment: Permission Thomas H.
• 11:08   Re: BUG #2712: could not fsync segment: Permission Magnus Hagander
• 13:42   Re: BUG #2712: could not fsync segment: Permission Tom Lane
• 13:48   Re: BUG #2712: could not fsync segment: Permission Thomas H.
• 14:01   Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL JEAN-PIERRE PELLETIER
• 19:36   Re: BUG #2712: could not fsync segment: Permission Tom Lane

10 November 2006

• 05:12   JDBC driver bug PreparedStatement.setNull(int,Types.BOOLEAN) David Green
• 05:12   BUG #2741: Double-free on error in ECPGconnect Peter Harris
• 05:12   BUG #2742: psql -c is not case sensitive 
• 05:13   BUG #2750: information_schema broken with primary and foreign key on the same column Stephen haberman
• 05:13   BUG #2744: pg_dump, ERROR: out of memory, Failed on request of size 270344621 aTz
• 05:13   BUG #2745: upgrade.bat refers to msi file name for version 8.1 ms 
• 05:13   BUG #2749: Function's final statement must be a SELECT Hagen
• 05:52   Re: BUG #2742: psql -c is not case sensitive Tom Lane
• 06:04   Re: BUG #2749: Function's final statement must be a SELECT Tom Lane
• 13:21   Re: JDBC driver bug PreparedStatement.setNull(int,Types.BOOLEAN) Kris Jurka
• 14:07   BUG #2751: contrib\pgxml.sql Dennis
• 14:07   BUG #2752: Website bug Denis
• 14:44   Re: BUG #2751: contrib\pgxml.sql Tom Lane
• 15:44   Re: BUG #2750: information_schema broken with primary and foreign key on the same column Tom Lane
• 22:00   Re: BUG #2732: pg_get_serial_sequence error Tom Lane
• 22:55   Re: BUG #2737: hash indexing large table fails, while btree of same index works Tom Lane

11 November 2006

• 07:18   Re: [PERFORM] BUG #2737: hash indexing large table fails,while btree of same index works Simon Riggs

12 November 2006

• 03:29   Re: [PATCHES] BUG #2704: pg_class.relchecks overflow problem Tom Lane
• 13:06   Re: 8.2beta1 (w32): server process crash (tsvector) Thomas H.
• 15:05   Re: 8.2beta1 (w32): server process crash (tsvector) Magnus Hagander
• 15:20   Re: 8.2beta1 (w32): server process crash (tsvector) imad
• 15:28   Re: 8.2beta1 (w32): server process crash (tsvector) Thomas H.
• 16:41   Re: 8.2beta1 (w32): server process crash (tsvector) Tom Lane
• 16:51   Re: 8.2beta1 (w32): server process crash (tsvector) Thomas H.
• 16:56   Re: 8.2beta1 (w32): server process crash (tsvector) Tom Lane
• 17:17   Re: 8.2beta1 (w32): server process crash (tsvector) Thomas H.
• 18:33   Re: 8.2beta1 (w32): server process crash (tsvector) Dave Page
• 19:34   Re: 8.2beta1 (w32): server process crash (tsvector) Magnus Hagander
• 21:38   BUG #2754: cache lookup failed for function 8470229 Roman Shterenzon
• 21:38   BUG #2755: strange select behavior Basil Evseenko

13 November 2006

• 03:58   Re: [HACKERS] [PATCHES] BUG #2704: pg_class.relchecks overflow Toru SHIMOGAKI
• 04:42   Re: BUG #2755: strange select behavior tomas@tuxteam.de
• 08:01   Re: 8.2beta1 (w32): server process crash (tsvector) Magnus Hagander
• 08:36   Re: 8.2beta1 (w32): server process crash (tsvector) Magnus Hagander

14 November 2006

• 12:41   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Andreas Lange
• 15:16   BUG #2758: missing quotes in SQL sentence scoanda
• 18:16   Re: BUG #2758: missing quotes in SQL sentence Jim C. Nasby
• 18:41   Re: BUG #2758: missing quotes in SQL sentence Dave Page
• 20:55   Re: BUG #2758: missing quotes in SQL sentence Peter Eisentraut

15 November 2006

• 07:28   Re: BUG #2758: missing quotes in SQL sentence Dave Page
• 09:21   Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio Zdenek Kotala
• 18:41   BUG #2759: \df doesn't show functions with no args Leon Miller-Out
• 18:58   How to crash postgres using savepoints Joseph Shraibman
• 20:39   Postgresql out-of-memory error Joe Malicki

16 November 2006

• 17:26   Re: 8.2beta1 (w32): server process crash (tsvector) Magnus Hagander
• 19:35   Re: How to crash postgres using savepoints Tom Lane
• 19:59   Re: How to crash postgres using savepoints Joseph Shraibman
• 19:59   Re: How to crash postgres using savepoints Alvaro Herrera
• 20:08   Re: How to crash postgres using savepoints Tom Lane
• 21:48   Re: [PERFORM] BUG #2737: hash indexing large table fails,while btree of same index works Tom Lane

17 November 2006

• 09:59   Re: [PERFORM] BUG #2737: hash indexing large tablefails,while btree of same index works Simon Riggs
• 13:38   Re: [PERFORM] BUG #2737: hash indexing largetablefails,while btree of same index works Simon Riggs
• 14:08   Re: [PERFORM] BUG #2737: hash indexing large tablefails,while btree of same index works Tom Lane
• 14:36   Re: [PERFORM] BUG #2737: hash indexing large tablefails,while Julius.Stroffek
• 18:46   Re: xlog lockup patch (was: BUG #2712: could not fsync segment: Permission) Thomas H.

20 November 2006

• 21:18   Re: xlog lockup patch (was: BUG #2712: could not fsync Bruce Momjian

21 November 2006

• 00:14   BUG #2761: Using NHibernate witn VS .NET 2.O Freddy Melo Acosta
• 00:14   Postgresql out-of-memory error Joe Malicki
• 00:14   BUG #2765: BUG #2419: could not reattach to shared memory Sergio Medeiros Santi
• 00:14   BUG #2772: Undefined Subroutine Pg::connectdb (" "); S.Balaji
• 00:14   BUG #2770: tomcat connection pool Brahma
• 00:14   BUG #2771: NULL values in FOREIGN KEY fields vincent
• 00:14   BUG #2760: log_min_duration_statement always logs to stderr Jonathan Ellis
• 00:14   BUG #2763: fat carlos
• 00:14   BUG #2766: erratic segfault in libpq/DBD::Pg Karl DeBieechop
• 00:14   Stored Procedure with more than one OUT Parameter manisha balwadkar
• 00:14   Re: [PERFORM] BUG #2737: hash indexing large tablefails,while btree of same index works Kenneth Marshall
• 00:14   BUG #2769: "invalid memory alloc request size " on startup Chris Jones
• 00:14   BUG #2767: Bug in avg(interval) Steffen Macke
• 00:14   BUG #2764: Capital letter in tables or columns not supported Ron Teitelbaum
• 00:15   BUG #2768: dates before year 1600 in timestamptz column give strange results Mikko Tiihonen
• 03:14   Re: BUG #2764: Capital letter in tables or columns not Reece Hart
• 03:15   Re: BUG #2767: Bug in avg(interval) Tom Lane
• 03:15   Re: BUG #2768: dates before year 1600 in timestamptz column give strange results Tom Lane
• 03:16   Re: BUG #2769: "invalid memory alloc request size " on startup Tom Lane
• 03:16   Re: BUG #2766: erratic segfault in libpq/DBD::Pg Tom Lane
• 03:17   Re: BUG #2759: \df doesn't show functions with no args Bruce Momjian
• 03:42   Re: BUG #2771: NULL values in FOREIGN KEY fields Jaime Casanova
• 03:47   Re: BUG #2771: NULL values in FOREIGN KEY fields Euler Taveira de Oliveira
• 03:58   Re: BUG #2764: Capital letter in tables or columns not supported Jaime Casanova
• 13:05   Re: BUG #2768: dates before year 1600 in timestamptz column give strange results Heikki Linnakangas
• 13:09   Re: BUG #2768: dates before year 1600 in timestamptz column give strange results Heikki Linnakangas
• 13:14   Re: BUG #2768: dates before year 1600 in timestamptz column give strange results Tom Lane
• 14:38   Re: BUG #2764: Capital letter in tables or columns not Bruce Momjian
• 14:53   Re: Postgresql out-of-memory error Tom Lane
• 15:11   Re: BUG #2768: dates before year 1600 in timestamptz column Mikko Tiihonen
• 15:11   PGSQL SETUP PROBLEM Sule, Olufemi (IITA)
• 15:11   BUG #2773: Problem pg_get_serial_sequence Amelio
• 15:11   210 - SQL STATE = 28000 Bill
• 15:11   Re: BUG #2767: Bug in avg(interval) Steffen Macke
• 16:08   Re: BUG #2773: Problem pg_get_serial_sequence Bruce Momjian
• 16:14   Re: BUG #2773: Problem pg_get_serial_sequence Stefan Kaltenbrunner
• 16:16   Re: BUG #2773: Problem pg_get_serial_sequence Tom Lane
• 21:20   Re: backup + restore fails Tom Lane

22 November 2006

• 00:17   Re: backup + restore fails Bruce Momjian
• 03:46   A bug or documentation error? Gurjeet Singh
• 12:27   Re: A bug or documentation error? Gurjeet Singh
• 12:40   Re: A bug or documentation error? Gurjeet Singh
• 12:51   Re: A bug or documentation error? Tom Lane
• 12:58   Re: A bug or documentation error? Gurjeet Singh
• 13:59   Re: A bug or documentation error? Tom Lane
• 18:28   Re: BUG #2772: Undefined Subroutine Pg::connectdb (" "); Bruno Wolff III

23 November 2006

• 02:49   Re: Operator Classes and ANALYZE Bruce Momjian
• 03:38   Re: global symbol conflict in Bruce Momjian

24 November 2006

• 20:04   PGSQL SETUP PROBLEM rahman sule
• 20:04   Re: BUG #2759: \df doesn't show functions with no args Leon Miller-Out
• 20:04   BUG #2779: Making an inherited table to a view causes could not open relation error in base table Sven Klemm
• 20:04   Error in postgresql after crash unable to restart this needs to be posted on -hackers or -bugs, so that tom, oleg and teodor can take a look anil maran
• 20:04   BUG #2778: make check failed Alex Deiter
• 20:04   Re: BUG #2768: dates before year 1600 in timestamptz column Mikko Tiihonen
• 20:05   BUG #2775: Error select Mas Kus
• 20:19   BUG #2774: Error select Mas Kus
• 20:21   BUG #2776: unable to access created user directory Raghava
• 20:22   PostgreSQL 8.1.5: regression tests fail on sparc Дейтер Александр Валериевич
• 20:37   Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table Tom Lane
• 20:45   Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table Alvaro Herrera
• 20:47   Re: BUG #2775: Error select Tom Lane
• 20:58   Re: BUG #2779: Making an inherited table to a view causes could not open relation error in base table Tom Lane
• 21:06   Re: PostgreSQL 8.1.5: regression tests fail on sparc Tom Lane

25 November 2006

• 07:16   Re: BUG #2776: unable to access created user directory tomas@tuxteam.de

26 November 2006

• 03:05   BUG #2780: could not fsync segment 0 Thomas H.
• 15:37   Re: BUG #2769: "invalid memory alloc request size " on startup Tom Lane
• 16:02   Re: PostgreSQL 8.1.5: regression tests fail on sparc Zdenek Kotala

27 November 2006

• 04:48   8.2rc1: vacuum full fills up disk space Thomas H.
• 05:24   Re: 8.2rc1: vacuum full fills up disk space Tom Lane
• 05:35   Re: 8.2rc1: vacuum full fills up disk space Thomas H.
• 10:26   multiple SRFs in SELECT clause. Kris Jurka
• 13:48   fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 13:58   Re: fsync and semctl errors with 8.1.5/win32 Magnus Hagander
• 14:28   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 15:13   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 15:41   Re: fsync and semctl errors with 8.1.5/win32 Dave Page
• 16:14   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 16:36   Re: 8.2rc1: vacuum full fills up disk space Heikki Linnakangas
• 17:06   Re: 8.2rc1: vacuum full fills up disk space Thomas H.
• 17:48   Re: multiple SRFs in SELECT clause. Tom Lane
• 21:10   Re: Unexpected sort order (suspected bug) Ron Mayer

28 November 2006

• 01:21   BUG #2782: Too Many open files in system Alaa El Gohary
• 01:21   BUG #2783: insufficient base table information for updating or refreshing mike
• 01:21   BUG #2784: Performance serious degrades over a period of a month Michael Simms
• 01:21   BUG #2781: database dump/restore problems Greg Peters
• 01:21   BUG #2785: Exception Issue Patrick Hayes
• 01:21   BUG #2787: postgresql-jdbc-8.1.407 won't install on RHEL4 Pete Deffendol
• 01:22   BUG #2786: PGADMIN 1.6 Gilberto Xavier
• 01:22   Re: BUG #2769: "invalid memory alloc request size " on Chris Jones
• 01:22   BUG #2789: problem with delete statement Lucian Capdefier
• 01:22   BUG #2788: Create Function operator Broken? Shawn Tayler
• 01:57   Re: BUG #2781: database dump/restore problems Tom Lane
• 01:59   Re: BUG #2784: Performance serious degrades over a period of a month Tom Lane
• 02:01   Re: BUG #2782: Too Many open files in system Tom Lane
• 02:06   Re: BUG #2785: Exception Issue Tom Lane
• 02:11   Re: BUG #2781: database dump/restore problems Thomas H.
• 03:25   Re: BUG #2784: Performance serious degrades over a period of a month Bruno Wolff III
• 03:36   Re: BUG #2781: database dump/restore problems Tom Lane
• 04:09   Re: BUG #2788: Create Function operator Broken? Stephan Szabo
• 07:58   Re: BUG #2786: PGADMIN 1.6 Dave Page
• 10:08   Re: BUG #2784: Performance serious degrades over a period of a month Heikki Linnakangas
• 11:27   BUG #2790: constructor for int2vector seems to be buggy Gurjeet Singh
• 11:36   Re: BUG #2781: database dump/restore problems Thomas H.
• 14:09   Re: BUG #2790: constructor for int2vector seems to be buggy Tom Lane
• 14:19   Re: BUG #2790: constructor for int2vector seems to be buggy Gurjeet Singh
• 15:54   Re: BUG #2785: Exception Issue pat hayes
• 15:54   BUG #2792: not able to install postgress Santhinesh Kumar
• 15:54   BUG #2791: Error while commiting Raman Dabhade
• 16:13   Re: BUG #2792: not able to install postgress Alvaro Herrera
• 16:22   could not rename temporary statistics file: No such file or directory Jeremy Haile
• 20:19   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 20:23   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 20:32   Re: fsync and semctl errors with 8.1.5/win32 Thomas H.
• 20:45   Re: fsync and semctl errors with 8.1.5/win32 Tom Lane
• 20:48   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 21:39   Re: fsync and semctl errors with 8.1.5/win32 Thomas H.
• 21:49   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile

29 November 2006

• 13:46   Re: BUG #2791: Error while commiting Michael Fuhr

30 November 2006

• 13:10   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 13:15   Re: fsync and semctl errors with 8.1.5/win32 Thomas H.
• 13:56   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile
• 14:11   Re: fsync and semctl errors with 8.1.5/win32 Thomas H.
• 15:04   Re: fsync and semctl errors with 8.1.5/win32 Thomas H.
• 15:08   Re: fsync and semctl errors with 8.1.5/win32 Bradley Russell
• 15:15   Re: fsync and semctl errors with 8.1.5/win32 Bradley Russell
• 15:49   BUG #2793: Cannot Install (Problem with permitions) Thiago dos Santos Alves
• 15:49   BUG #2795: can't start service postgre Ilia
• 15:49   BUG #2794: corrupted table pk index 
• 16:11   Re: BUG #2795: can't start service postgre Jeremy Haile
• 20:15   Re: fsync and semctl errors with 8.1.5/win32 Jeremy Haile