Re: timestamp in pg_dump

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: timestamp in pg_dump
Дата
Msg-id
Pine.LNX.4.30.0102051828020.762-100000@peter.localdomain
Ответ на
timestamp in pg_dump (Thomas Lockhart)
Список
Дерево обсуждения
Re: timestamp in pg_dump Thomas Lockhart <lockhart@alumni.caltech.edu>
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/


В списке pgsql-hackers по дате отправления
От: Lamar Owen
Дата:
Сообщение: Re: pg_ctl wish list
От: Rod Taylor
Дата:
Сообщение: Foreign Key issue - pg_shadow
FAQ