[BUGS] Adding new columns - bug

2008-02-11 Thread Michael Andreasen
I have a found a bug when adding a new column to an existing table. This happens in 6.1 and 6.2, not able to test 6.3 yet. This is the process I am doing; alter table product add column search_priority int default 0; update product set search_priority = 0; search_priority,count(*) from product

Re: [BUGS] Adding new columns - bug

2008-02-11 Thread Michael Andreasen
This happens in 6.1 and 6.2, not able to test 6.3 yet. Sorry typo... should be 8.x ofcourse. On 11/02/2008, Michael Andreasen [EMAIL PROTECTED] wrote: I have a found a bug when adding a new column to an existing table. This happens in 6.1 and 6.2, not able to test 6.3 yet

[BUGS] pg_restore problem

2006-05-29 Thread Michael Andreasen
I have a problem restoring our large database. This has only stared happening since we moved to 8.1.x We are currently on 8.1.3. We perform an over night dump of the database as follows; pg_dump -Ft $db | bzip2 $db.dump.tbz This happens fine, without any errors. On our backup machine also