[BUGS] BUG #1542: pg_dump seg fault

2005-03-14 Thread Andrew Slobodyanyk
The following bug has been logged online: Bug reference: 1542 Logged by: Andrew Slobodyanyk Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: linux 2.4.26, gcc 3.2.2 Description:pg_dump seg fault Details: After power failure any operation

Re: [BUGS] CC Date format code defaults to current centry

2005-03-14 Thread Andre Maasikas
Bruce Momjian wrote: Joe Brown wrote: joe=> select to_date('19450323','CCYYMMDD'); to_date 2045-03-23 (1 row) joe=> select to_date('19450323','MMDD'); to_date 1945-03-23 (1 row) I thought the former would be "more" correct. But it seems I am mistaken. Uh, 194

Re: [BUGS] BUG #1537: alter table statement

2005-03-14 Thread Michael Fuhr
On Mon, Mar 14, 2005 at 01:20:06PM +0530, Biju wrote: > I am using postgresql version 7.2.2 As Tom observed, you might be reading documentation for a later version and are trying to do something that 7.2 doesn't support. Here's a link to the 7.2 documentation: http://www.postgresql.org/docs/7.2/

Re: [BUGS] BUG #1542: pg_dump seg fault

2005-03-14 Thread Tom Lane
"Andrew Slobodyanyk" <[EMAIL PROTECTED]> writes: > Description:pg_dump seg fault > After power failure any operation with tbl_test return "ERROR: could not > open relation 1663/17242/40429: No such file or directory". I try to get > information from other tables, but with or without (after