[BUGS] date -> timestamp casting bug (integer datetimes)

2007-05-05 Thread Neil Conway
When integer datetimes are in use, the legal range of the "date" type actually exceeds that of the "timestamp" type. However, the cast from date => timestamp fails to take this into account: postgres=# select '01-01-5874896'::date::timestamp; timestamp --

Re: [BUGS] BUG #1063: tcp/ip

2007-05-05 Thread Stefano T
i've this problem but on windowsxp.. how i can resolve? "PostgreSQL Bugs List" wrote: > The following bug has been logged online: > > Bug reference: 1063 > Logged by: forty > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4 > > Operating system: windows me > > De

Re: [BUGS] Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

2007-05-05 Thread Russell Smith
Stephen Frost wrote: * Tom Lane ([EMAIL PROTECTED]) wrote: Stephen Frost <[EMAIL PROTECTED]> writes: If you're saying we don't currently warn if a revoke leaves the priviledges in-tact for the right and target, I'm not sure you can currently get in a state where it'd be possible to run