Re: [BUGS] BUG #3607: timestamp is behaving strangely

2007-09-07 Thread Tom Lane
"Cade Cairns" <[EMAIL PROTECTED]> writes: > test=> select '2007-05-11 09:33:01.167885'::timestamp without time zone, > ('epoch'::timestamp without time zone + '1178875981.167885 > seconds'::interval)::timestamp without time zone; > timestamp | timestamp > ---

[BUGS] BUG #3607: timestamp is behaving strangely

2007-09-07 Thread Cade Cairns
The following bug has been logged online: Bug reference: 3607 Logged by: Cade Cairns Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Mac OS X 10.4.10 Description:timestamp is behaving strangely Details: test=> select '2007-05-11 09:33:01

Re: [BUGS] BUG #3606: Query Plan Failure or Index Corruption?

2007-09-07 Thread Tom Lane
"David Tulloss" <[EMAIL PROTECTED]> writes: > I am operating under the assumption that we have an index corruption because > things work upon restore and then degrade under usage. It sounds much more like you're not vacuuming often enough and/or don't have max_fsm_pages set high enough. However,

[BUGS] BUG #3606: Query Plan Failure or Index Corruption?

2007-09-07 Thread David Tulloss
The following bug has been logged online: Bug reference: 3606 Logged by: David Tulloss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Description:Query Plan Failure or Index Corruption? Details: I have a very complex view that is

Re: [BUGS] BUG #3605: impossible loading

2007-09-07 Thread Heikki Linnakangas
Dave Page wrote: > Christian PANEL wrote: >> I have tried many mirrors sites to download postgres but it is impossible >> with a low-debit connection (56k) : all server shutdown connexion after 1 >> hour (about 10MO data). >> How can I have and try Postgres? >> Is it allow for only a part of poulat

Re: [BUGS] BUG #3605: impossible loading

2007-09-07 Thread Dave Page
Christian PANEL wrote: The following bug has been logged online: Bug reference: 3605 Logged by: Christian PANEL Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:impossible loading Details: I have tried many mirrors

[BUGS] BUG #3605: impossible loading

2007-09-07 Thread Christian PANEL
The following bug has been logged online: Bug reference: 3605 Logged by: Christian PANEL Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:impossible loading Details: I have tried many mirrors sites to download postgre

Re: [BUGS] 'on insert do instead' rule with a where clause responds 'INSERT 0 0'

2007-09-07 Thread Tom Lane
Julius Stroffek <[EMAIL PROTECTED]> writes: > Attached is the example script 'repro.sql' which creates two relations > tab1 and tab2. It also creates a rule on tab1 which simply does insert > into tab2. The insert statement into tab1 is executed afterwards. It > responds with 'INSERT 0 1'. Howev

[BUGS] 'on insert do instead' rule with a where clause responds 'INSERT 0 0'

2007-09-07 Thread Julius Stroffek
Hi, Attached is the example script 'repro.sql' which creates two relations tab1 and tab2. It also creates a rule on tab1 which simply does insert into tab2. The insert statement into tab1 is executed afterwards. It responds with 'INSERT 0 1'. However if I would create the same rule with the w