Re: timestamp in pg_dump

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: lockhart(at)fourpalms(dot)org, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: timestamp in pg_dump
Date: 2001-02-06 04:46:47
Message-ID: 3A7F81B7.3B34030F@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-02-06 04:48:47 Re: How to modify type in table?
Previous Message Bruce Momjian 2001-02-06 04:31:31 Re: Foreign Key issue - pg_shadow