[BUGS] BUG #1993: Adding/subtracting negative time intervals changes time zone of result

2005-10-24 Thread Nicholas
The following bug has been logged online: Bug reference: 1993 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description:Adding/subtracting negative time intervals changes time zone of result

[BUGS] BUG #1994: Ignore the last bug report; this is a confusing time zone feature, not a bug

2005-10-24 Thread Nicholas
The following bug has been logged online: Bug reference: 1994 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.4,8.1 Operating system: Gentoo Linux Description:Ignore the last bug report; this is a confusing time zone feature, not a

[BUGS] BUG #2218: Variables selected in VIEWs under different names break queries using those views

2006-01-28 Thread Nicholas
The following bug has been logged online: Bug reference: 2218 Logged by: Nicholas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Gentoo Linux x86 Description:Variables selected in VIEWs under different names break queries using those

[BUGS] BUG #2872: SELECT from view with OR fast in 8.1, slow in 8.2

2007-01-03 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 2872 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: Linux (AMD64) Description:SELECT from view with OR fast in 8.1, slow in 8.2 Details: Sorry that I

[BUGS] Query producing the wrong results?

2004-05-03 Thread Nicholas Howell
ebatcher=> select version(); version - PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) (1

[BUGS] BUG #1649: Date calculation year off-by-one error

2005-05-05 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 1649 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Gentoo Linux Description:Date calculation year off-by-one error Details: This is definitely not

[BUGS] BUG #1650: Upgraded postgres, problem went away

2005-05-05 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 1650 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Gentoo Linux Description:Upgraded postgres, problem went away Details: 8.0.2 is not marked as

[BUGS] BUG #1648: ISO Year ignores time zone?

2005-05-05 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 1648 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Gentoo Linux Description:ISO Year ignores time zone? Details: rt3=# SELECT to_char(timestamp with

Re: [BUGS] BUG #1993: Adding/subtracting negative time intervals

2005-10-26 Thread Nicholas Vinen
files. (I'm sure I can work it out myself if necessary, but I'm a little busy at the moment). BTW, Postgres' date functions are *great* except for these minor problems. The best I've ever used. Thanks! Nicholas Klint Gore wrote: On Tue, 25 Oct 2005 13:28:00 -0400,

[BUGS] BUG #2285: Can not access database after successful PITR - file naming problems

2006-02-27 Thread Nicholas Vinen
The following bug has been logged online: Bug reference: 2285 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Gentoo Linux x86 Description:Can not access database after successful PITR - file naming problems