Re: timestamp in pg_dump - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: timestamp in pg_dump
Date
Msg-id 3A7F81B7.3B34030F@alumni.caltech.edu
Whole thread Raw
In response to Re: timestamp in pg_dump  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> > I'd like to have pg_dump for 7.1 produce "timestamp with time zone" when
> > dealing with timestamp type(s). That will prepare us for introducing a
> > timestamp type without time zones, while allowing reasonable upgrades to
> > 7.2.
> Did that.

Great!

> But given that 'timestamp' is really 'timestamp with time zone' and there
> is no 'timestamp without time zone', isn't there something wrong with the
> documentation?  See User's Guide, table 3-6:

Hmm. Not sure *where* some of that info came from; perhaps it is a
holdover from when timestamp was implemented as a 4 byte integer. Or it
was space aliens ;) Will update asap. Thanks for catching it...
                - Thomas


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Foreign Key issue - pg_shadow
Next
From: Thomas Lockhart
Date:
Subject: Re: How to modify type in table?