Re: [BUGS] Timezone issues with Postrres

2011-09-23 Thread Magnus Hagander
On Thu, Sep 22, 2011 at 07:42, Tom Lane wrote: > pratikchirania writes: >> 1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with >> PostgreSQL 8.3/9.0 >> 2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra >> display >> 4. There is NO DST for CST (Central

Re: [BUGS] drop enum problem

2011-09-23 Thread Gavin Flower
On 23/09/11 10:43, Gavin Flower wrote: On a LInux 64 biut system: $ psql psql (9.1.0) Type "help" for help. gavin=> DROP TYPE raindow; ERROR: type "raindow" does not exist gavin=> CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple'); ERROR: type "rainbow" alrea

Re: [BUGS] BUG #6218: TRAP: FailedAssertion( "!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

2011-09-23 Thread YAMAMOTO Takashi
hi, > "YAMAMOTO Takashi" writes: >> 9.2devel (2562dcea811eb642e1c5442e1ede9fe268278157) > >> ERROR: could not serialize access due to concurrent update >> STATEMENT: UPDATE file SET atime = current_timestamp WHERE fileid = $1 >> TRAP: FailedAssertion("!(owner->nsnapshots == 0)", File: "resowne

[BUGS] BUG #6220: Flagstaff

2011-09-23 Thread Nicolas Beuzeboc
The following bug has been logged online: Bug reference: 6220 Logged by: Nicolas Beuzeboc Email address: nicolasbeuze...@gmail.com PostgreSQL version: 8.4.8 Operating system: Ubuntu Natty Description:Flagstaff Details: There is a month difference between the query r

Re: [BUGS] Timezone issues with Postrres

2011-09-23 Thread Tom Lane
Magnus Hagander writes: > On Thu, Sep 22, 2011 at 07:42, Tom Lane wrote: >> I think we ought to map "Central America Standard Time" to plain CST6. >> >> Magnus, AFAICT from the commit logs, that lookup table was your work to >> begin with --- do you remember anything about the reasoning for the >

[BUGS] comment fixes

2011-09-23 Thread YAMAMOTO Takashi
hi, see the following patch. it seems some function names in the comment are out of sync with the reality. YAMAMOTO Takashi diff --git a/src/backend/executor/execProcnode.c b/src/backend/executor/execProcnode.c index 8bdfad2..284fc6a 100644 --- a/src/backend/executor/execProcnode.c +++ b/src/ba