Re: [BUGS] Small problem in contrib/dbase/dbf2pg.c

2003-07-23 Thread Bruce Momjian
Thomas, would you send me a context diff (diff -c) of the change and I will get into 7.4. Thanks. --- Thomas Behr wrote: > Your name : Thomas Behr > Your email address : [EMAIL PROTECTED] > System Configu

Re: [BUGS] [GENERAL] Convert TimeStamp to Date

2003-07-23 Thread Tom Lane
Dmitry Tkach <[EMAIL PROTECTED]> writes: > In 7.3 (and 7.4) timestamptz_date () is still doing that (and select > '1999-12-31 00:00:01'::timestamptz::date still works), > *but* timestamp_date() is changed for some reason to just divide the > timestamp by the number of microseconds per day, that i

Re: [BUGS] [GENERAL] Convert TimeStamp to Date

2003-07-23 Thread Dmitry Tkach
Yep ... looks like it got broken in 7.3. 7.2.4 works fine, but 7.3 (and CVS tip) doesn't. This is because in 7.2, timestamp_date () and timestamptz_date () do the same thing - convert the time to Julian date and then subtruct the offset for Y2K, and both work. In 7.3 (and 7.4) timestamptz_date (

Re: [BUGS] HELP! BUG? pg_dump mucks up grant/revoke

2003-07-23 Thread Misha Gale
Dear All, With regard to the rather old bug report about pg_dump outputting ACL commands on views before the views have been created (see http://archives.postgresql.org/pgsql-general/2001-07/msg01051.php), I take it this bug is fixed in the latest release? More importantly, is there anywhere I ca