Thread: timestamp in pg_dump

timestamp in pg_dump

From
Thomas Lockhart
Date:
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.

Comments? Would a pg_dump guru be willing to take this on? Should be
"easy", since afaik we already map some internal types to external
SQL-standard names...
                    - Thomas


Re: timestamp in pg_dump

From
Peter Eisentraut
Date:
Thomas Lockhart writes:

> 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.
>
> Comments? Would a pg_dump guru be willing to take this on? Should be
> "easy", since afaik we already map some internal types to external
> SQL-standard names...

Did that.

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:

http://www.postgresql.org/devel-corner/docs/postgres/datatype-datetime.htm


-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



Re: timestamp in pg_dump

From
Thomas Lockhart
Date:
> > 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