Re: [BUGS] alter column type (from timestamp to date) violates not null

2007-03-10 Thread Michael Fuhr
On Fri, Mar 09, 2007 at 04:55:59AM -0800, psmith wrote: > When change a column type from timestamp to date, the 'infinity' and '- > infinity' values will be NULL. Even if the column has a not null > constraint. [...] >version > ---

Re: [BUGS] alter column type (from timestamp to date) violates not null

2007-03-10 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Fri, Mar 09, 2007 at 04:55:59AM -0800, psmith wrote: >> When change a column type from timestamp to date, the 'infinity' and '- >> infinity' values will be NULL. Even if the column has a not null >> constraint. > This appears to be fixed already: http

[BUGS] BUG #3110: Online Backup introduces Duplicate OIDs

2007-03-10 Thread Randy Isbell \(jisbell\)
A bit more information. I found that if I take an offline backup created around the same time as my online backup, roll forward the transaction log files included in the offline backup using a recovery.conf file, the duplicate records do NOT exist. Therefore it seems there is no corruption in

Re: [BUGS] BUG #3110: Online Backup introduces Duplicate OIDs

2007-03-10 Thread Tom Lane
"Randy Isbell \(jisbell\)" <[EMAIL PROTECTED]> writes: > I found that if I take an offline backup created around the same time as > my online backup, roll forward the transaction log files included in the > offline backup using a recovery.conf file, the duplicate records do NOT > exist. > Therefore