Mailing lists [pgsql-bugs]

1 February 2007

• 07:22   Re: BUG #2948: default null values for not-null domains Peter Eisentraut
• 12:23   Re: BUG #2948: default null values for not-null domains Sergiy Vyshnevetskiy
• 13:33   Re: BUG #2948: default null values for not-null domains Tom Lane
• 14:04   Re: BUG #2948: default null values for not-null domains Sergiy Vyshnevetskiy
• 14:43   BUG #2954: null is not checked against domain constraints in return clause Sergiy Vyshnevetskiy
• 16:25   Re: BUG #2954: null is not checked against domain constraints in return clause Sergiy Vyshnevetskiy
• 16:35   Re: BUG #2948: default null values for not-null domains Tom Lane
• 17:10   Re: BUG #2948: default null values for not-null domains Sergiy Vyshnevetskiy
• 18:28   Re: BUG #2948: default null values for not-null domains Tom Lane
• 18:35   Re: BUG #2954: null is not checked against domain constraints in return clause Tom Lane
• 20:51   Re: BUG #2948: default null values for not-null domains Sergiy Vyshnevetskiy

2 February 2007

• 00:56   BUG #2952: where is the user guide Jessica
• 00:56   BUG #2953: index scan, feature request michael
• 01:18   Re: BUG #2953: index scan, feature request Tom Lane
• 06:40   Re: BUG #2952: where is the user guide Peter Eisentraut
• 07:13   Re: BUG #2953: index scan, feature request Magnus Hagander

3 February 2007

• 22:56   Re: "Julian day" date format is off by 12 hours Bruce Momjian

4 February 2007

• 05:17   Re: "Julian day" date format is off by 12 hours Shelby Cain
• 14:42   BUG #2967: BUG #2881: FATAL: could not reattach to shared memory (Win32) Mika Vimpari
• 14:45   Re: BUG #2967: BUG #2881: FATAL: could not reattach to shared memory (Win32) Magnus Hagander
• 17:11   Re: BUG #2967: BUG #2881: FATAL: could not reattach to shared memory (Win32) Magnus Hagander

6 February 2007

• 02:10   BUG #2956: ECPG does not treat multibyte characters correctly. Toshi Harada
• 02:10   BUG #2958: ERROR: 53200: out of memory Anton Andreev
• 02:10   BUG #2959: Non-usual error when using jdbc driver into a Java WebStart application Adriano
• 02:10   BUG #2960: missing string replace function ODBC driver Dave Claes
• 02:10   BUG #2961: NULL values in subselects force NOT IN to false Aaron Logue
• 02:11   BUG #2962: 8.2.1 lo_creat Documentation incorrect? Gary Chambers
• 02:11   BUG #2963: PQprepare and transactions. DUVAL Jean-Pierre
• 02:11   BUG #2969: Inaccuracies in Solaris FAQ Rich Teer
• 02:25   Re: BUG #2961: NULL values in subselects force NOT IN to false Stephan Szabo
• 04:30   Re: BUG #2963: PQprepare and transactions. Tom Lane
• 04:30   Re: BUG #2962: 8.2.1 lo_creat Documentation incorrect? Tom Lane
• 06:53   BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update' Martin Pitt
• 08:36   8.2.2 regression with indices on user functions, 8.2.1 works Tomas Szepe
• 14:57   Strange "Table has type character varying, but query expects character varying" errors Ümit Öztosun
• 15:11   BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed William ZHANG
• 15:11   BUG #2972: Upgrading 8.2.1 to 8.2.2 changes port on some commands Rul
• 15:26   Re: BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update' Tom Lane
• 15:37   Re: Strange "Table has type character varying, but query expects character varying" errors Tom Lane
• 15:55   Re: Strange "Table has type character varying, but query expects character varying" errors Ümit Öztosun
• 16:44   Re: Strange "Table has type character varying, but query expects character varying" errors Martin Pitt
• 17:14   Re: BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update' Martin Pitt
• 19:27   Re: 8.2.2 regression with indices on user functions, 8.2.1 works Tom Lane
• 21:50   Re: BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed Tom Lane
• 22:48   Re: BUG #2961: NULL values in subselects force NOT IN to false Stephan Szabo

7 February 2007

• 01:09   Re: Strange "Table has type character varying, but query expects character varying" errors Martin Pitt
• 01:09   BUG #2973: Compile Error with MIPSpro compiler Thomas
• 01:09   Re: BUG #2961: NULL values in subselects force NOT IN to false Aaron Logue
• 01:09   Re: BUG #2962: 8.2.1 lo_creat Documentation incorrect? Gary Chambers
• 09:24   BUG #2977: dow doesn't conform to ISO-8601 Adriaan van Os
• 09:57   Re: BUG #2977: dow doesn't conform to ISO-8601 Peter Eisentraut
• 19:05   ah, the irony - an html error on the pgsql-bugs web page rob_spellberg
• 20:08   server crash: displaying sqlerrm in exception block Asif Ali

8 February 2007

• 00:18   Re: server crash: displaying sqlerrm in exception block Tom Lane
• 13:54   Re: server crash: displaying sqlerrm in exception block Tom Lane
• 14:18   Re: server crash: displaying sqlerrm in exception block Asif Ali
• 14:37   Re: server crash: displaying sqlerrm in exception block Tom Lane
• 15:27   Possible problem with type bigserial in pg_dump/pg_restore Marcio A. Sepp
• 15:27   BUG #2974: broken CHECK constraint with varchar Michal Schwarz
• 15:27   BUG #2980: check constraint fails on update Walter Cruz
• 15:27   BUG #2981: server crash Asif
• 15:27   BUG #2975: UNIQUE INDEX doesn't work Steven
• 15:27   BUG #2982: Install broken when not installed as a service Dan Armbrust
• 15:28   ENC: Possible problem with type bigserial in pg_dump/pg_restore Marcio A. Sepp
• 15:28   Re: 8.2.2 regression with indices on user functions, 8.2.1 works Tomas Szepe
• 15:28   BUG #2979: Functional indexes ERROR while updating table Roman Grigorovich
• 15:37   Re: BUG #2979: Functional indexes ERROR while updating table Guillaume Smet
• 15:44   Re: BUG #2980: check constraint fails on update Heikki Linnakangas
• 15:55   Re: Possible problem with type bigserial in pg_dump/pg_restore Tom Lane
• 15:57   Re: BUG #2974: broken CHECK constraint with varchar Bruce Momjian
• 15:57   Re: BUG #2975: UNIQUE INDEX doesn't work Bruce Momjian
• 19:00   Re: server crash: displaying sqlerrm in exception block Asif Ali

9 February 2007

• 17:00   Weird misinterpretation of EXECUTE in PL/pgSQL Peter Eisentraut
• 17:54   Re: Weird misinterpretation of EXECUTE in PL/pgSQL Tom Lane
• 22:17   Re: BUG #2393: update fails with unique constraint violation Lar
• 23:41   Re: BUG #2393: update fails with unique constraint violation Tom Lane

12 February 2007

• 01:53   Re: BUG #2975: UNIQUE INDEX doesn't work Michael Fuhr
• 02:35   BUG #2983: Nonsense error: "Table has type interval, but query expects interval" David Flater
• 02:35   BUG #2984: Bug Creating or Updating a View Gabriel Bravo
• 03:09   Re: BUG #2983: Nonsense error: "Table has type interval, but query expects interval" Tom Lane
• 03:54   Re: BUG #2984: Bug Creating or Updating a View Tom Lane
• 14:49   Re: BUG #2969: Inaccuracies in Solaris FAQ Zdenek Kotala
• 16:52   BUG #2994: avg() calculates wrong on Interval-type Frank F. Burmo
• 16:53   BUG #2993: The program "postgres" is needed by initdb but was not found ... Filippo Toso
• 19:03   Re: BUG #2993: The program "postgres" is needed by initdb but was not found ... Magnus Hagander
• 20:15   Re: BUG #2994: avg() calculates wrong on Interval-type Tom Lane
• 22:19   Re: BUG #2994: avg() calculates wrong on Interval-type Peter Eisentraut
• 23:01   Re: BUG #2994: avg() calculates wrong on Interval-type Tom Lane

14 February 2007

• 05:59   BUG #2995: PSQLRestore crash and MemoryLeaks! Bruno
• 05:59   Re: BUG #2993: The program "postgres" is needed by initdb but was not found ... Filippo Toso
• 05:59   BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms Anthony Taylor
• 05:59   BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE) Floyd Shackelford
• 05:59   BUG #3000: Linking problem laurent faillie
• 06:00   BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing Phil Endecott
• 06:00   BUG #2998: Installation Failed due to Permissions Michael
• 06:00   BUG #3005: please help roland diaz
• 06:25   Re: BUG #2995: PSQLRestore crash and MemoryLeaks! Pavel Golub
• 06:34   Re: BUG #3000: Linking problem Tom Lane
• 06:47   Re: BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing Tom Lane
• 06:54   Re: BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms Tom Lane
• 10:04   Re: BUG #2993: The program "postgres" is needed by initdb but was not found ... Magnus Hagander
• 10:05   Re: BUG #2998: Installation Failed due to Permissions Magnus Hagander
• 13:48   Re: BUG #2975: UNIQUE INDEX doesn't work Michael Fuhr
• 16:16   Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE) Bruce Momjian
• 17:06   Re: BUG #2993: The program "postgres" is needed by initdb but was not found ... Magnus Hagander
• 17:57   Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE) Bruce Momjian
• 21:14   Segfaults and assertion failures with not too extraordinary views and queries Phil Frost
• 21:49   Re: Segfaults and assertion failures with not too extraordinary views and queries Tom Lane

15 February 2007

• 02:14   Re: Segfaults and assertion failures with not too extraordinary views and queries Tom Lane
• 13:39   Re: Segfaults and assertion failures with not too extraordinary views and queries Phil Frost
• 14:43   Fwd: Re: BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing Phil Endecott
• 16:46   Postgresql 8.1.8 Initdb not started DNS
• 16:46   BUG #3008: Unable to compile this for 32-bit Ashwini
• 16:46   BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN. Pelle Johansson
• 16:46   Re: BUG #3002: PQexecParams only supports some commands; needs improved error reporting, documenting or fixing Phil Endecott
• 16:51   Re: BUG #2993: The program "postgres" is needed by initdb but was not found ... Filippo Toso
• 17:21   Re: Segfaults and assertion failures with not too extraordinary views and queries Phil Frost
• 17:52   BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. 
• 18:54   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Tom Lane
• 19:50   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Unmesh Churi

16 February 2007

• 01:15   Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN. Tom Lane
• 02:52   Re: Segfaults and assertion failures with not too extraordinary views and queries Tom Lane
• 12:46   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Tom Lane
• 20:02   Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN. Tom Lane
• 20:59   Re: Segfaults and assertion failures with not too extraordinary views and queries Phil Frost
• 23:29   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Unmesh Churi

18 February 2007

• 11:21   BUG #3026: 8.2 FOR DEBIAN !!! plzzzz ^^ Skatepark Insaen
• 15:16   Re: BUG #3026: 8.2 FOR DEBIAN !!! plzzzz ^^ tomas@tuxteam.de
• 15:30   Re: BUG #3026: 8.2 FOR DEBIAN !!! plzzzz ^^ Milen A. Radev
• 20:58   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Tom Lane

19 February 2007

• 17:52   BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement Arjen van der Meijden
• 19:46   Re: BUG #2973: Compile Error with MIPSpro compiler Bruce Momjian
• 20:25   Re: BUG #2969: Inaccuracies in Solaris FAQ Bruce Momjian
• 21:50   Re: "Julian day" date format is off by 12 hours Bruce Momjian

20 February 2007

• 02:42   Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement Tom Lane
• 02:47   Re: BUG #2913: Subscript on multidimensional array yields no value Bruce Momjian
• 05:42   Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement Arjen van der Meijden
• 06:08   Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement Tom Lane
• 06:21   Re: BUG #3031: PHP (and others?) cannot close a connection when "in" a COPY-statement Arjen van der Meijden
• 12:16   Re: BUG #2973: Compile Error with MIPSpro compiler Michael Meskes
• 22:52   Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. Unmesh Churi

21 February 2007

• 15:30   Re: BUG #2969: Inaccuracies in Solaris FAQ Zdenek Kotala
• 18:56   pg_dump and truncate Feng Chen

22 February 2007

• 06:28   Re: pg_dump and truncate Tom Lane
• 15:42   Re: pg_dump and truncate Feng Chen
• 15:49   BUG #3056: strange behave of CHECK constraint Pavel Stehule
• 16:48   Re: BUG #3056: strange behave of CHECK constraint Douglas Toltzman
• 16:55   Re: BUG #3056: strange behave of CHECK constraint Peter Eisentraut
• 21:39   Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN. Pelle Johansson
• 21:39   BUG #3030: Unable to query SQL_WCHAR column via ODBC Dr. Axel Reimann
• 21:39   BUG #3033: performance issue with self join Luigi Tarenga
• 21:39   BUG #3032: Commit hung for days Craig White
• 21:39   BUG #3039: install completely but can't connect to server Jessica
• 21:39   BUG #3041: Universal Binary Support in Configure Matt Smith
• 21:39   BUG #3049: psql does not honor md5 in pg_hba.conf file Aaron Zedonis
• 21:39   BUG #3054: getopt_long () misbehaviour Tux
• 21:44   BUG #3044: what is correct configuration? Jessica
• 21:44   BUG #3052: Inconsistent results from PQexec... with rules brian blakey
• 21:44   BUG #3046: odbc zip file corrupt Cedric Scott
• 21:45   BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied Jessica
• 21:45   BUG #3051: FATAL: too many trigger records found for relation "pg_authid" Juan
• 21:46   Re: BUG #2973: Compile Error with MIPSpro compiler Thomas Fromm
• 21:50   BUG #3048: pg_dump dumps intarray metadata incorrectly Dmitry Koterov
• 21:50   BUG #3040: Domain type handling change in 8.2.2 breaks declarations Dreas Nielsen
• 21:50   BUG #3037: strange behave of CHECK constraint Pavel Stehule
• 21:50   BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys Eli Green
• 23:05   Unsubscribe me vishal saberwal

23 February 2007

• 00:24   Re: BUG #3051: FATAL: too many trigger records found for relation "pg_authid" Alvaro Herrera
• 03:48   Re: BUG #3040: Domain type handling change in 8.2.2 breaks declarations Tom Lane
• 03:54   Re: BUG #3037: strange behave of CHECK constraint Tom Lane
• 04:23   Re: BUG #3054: getopt_long () misbehaviour Tom Lane
• 04:25   Re: BUG #3039: install completely but can't connect to server Tom Lane
• 05:38   ERROR: relation "pg_catalog.pg_user" does not exist guru@ap.nic.in
• 05:43   Re: BUG #3037: strange behave of CHECK constraint Pavel Stehule
• 06:02   Re: ERROR: relation "pg_catalog.pg_user" does not exist Tom Lane
• 07:29   Re: BUG #3032: Commit hung for days Magnus Hagander
• 07:31   Re: BUG #3049: psql does not honor md5 in pg_hba.conf file Magnus Hagander
• 07:54   Re: BUG #3033: performance issue with self join tomas@tuxteam.de
• 07:56   Re: BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied tomas@tuxteam.de
• 15:06   Re: BUG #3052: Inconsistent results from PQexec... with rules Tom Lane
• 15:17   Re: BUG #3048: pg_dump dumps intarray metadata incorrectly Tom Lane
• 15:18   Re: BUG #2969: Inaccuracies in Solaris FAQ Zdenek Kotala
• 15:35   Re: BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys Tom Lane
• 17:30   Re: BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys Peter Eisentraut
• 17:38   Re: BUG #2969: Inaccuracies in Solaris FAQ Bruce Momjian
• 18:54   Re: BUG #2969: Inaccuracies in Solaris FAQ Peter Eisentraut

25 February 2007

• 16:11   BUG #3064: In Stored Procedures (pgplgql Fridman Garri
• 16:11   Re: BUG #3032: Commit hung for days Craig White
• 16:11   BUG #3059: psql to 'postgres' shortcut Raymond Naseef
• 16:17   Spelling error in 8.1.6-1 Windows Error Dialog typo Keith Turner
• 16:18   BUG #3065: Bug in stored procedure EXEPTION handling or in plpgsql ? Fridman Garri
• 16:18   BUG #3067: Unnecessary lock blocks reindex Axel Noltemeier
• 16:18   Re: BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys Eli Green
• 16:19   Re: BUG #3048: pg_dump dumps intarray metadata incorrectly Dmitry Koterov
• 16:23   Re: BUG #2969: Inaccuracies in Solaris FAQ Rich Teer
• 16:40   Re: BUG #3064: In Stored Procedures (pgplgql Alvaro Herrera
• 17:15   Re: BUG #3067: Unnecessary lock blocks reindex Tom Lane

26 February 2007

• 13:46   Re: BUG #3059: psql to 'postgres' shortcut Bruce Momjian
• 14:21   Re: BUG #2969: Inaccuracies in Solaris FAQ Bruce Momjian
• 15:21   BUG #3079: pg_dump doesn't dump datascheme with uppercase letters in Eugene
• 16:43   Re: BUG #3079: pg_dump doesn't dump datascheme with uppercase letters in Tom Lane

27 February 2007

• 11:46   Re: [PATCHES] BUG #2969: Inaccuracies in Solaris FAQ Zdenek Kotala
• 12:28   Re: BUG #3059: psql to 'postgres' shortcut Magnus Hagander
• 12:40   Re: Spelling error in 8.1.6-1 Windows Error Dialog typo Magnus Hagander
• 13:06   Re: BUG #3059: psql to 'postgres' shortcut Phil Frost
• 13:24   Re: BUG #3059: psql to 'postgres' shortcut Magnus Hagander
• 18:08   Re: BUG #3059: psql to 'postgres' shortcut Bruce Momjian
• 18:10   Re: [PATCHES] BUG #2969: Inaccuracies in Solaris FAQ Bruce Momjian

28 February 2007

• 09:36   pg_autovacuum and REINDEX at the same time (?) Janar Kartau
• 10:16   Re: pg_autovacuum and REINDEX at the same time (?) Heikki Linnakangas
• 10:41   Re: pg_autovacuum and REINDEX at the same time (?) Janar Kartau
• 11:12   Re: pg_autovacuum and REINDEX at the same time (?) Heikki Linnakangas