Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> It seems that even though I declare a columns to be of type timestamp
> without time zone it gets created as a data type *with* a time zone?
That is the behavior in 7.2; it's a transient state to help people
migrate from our old not-very-SQL-compliant datatype names.
In 7.3 "timestamp" will mean "timestamp without time zone" per spec.
> Here my SQL:
> create table MEMBERS (
> last_login timestamp without time zone [0],
> );
> I then do a "\d members" and get:
> last_login | timestamp with time zone[] |
There's also a nasty little bug in the 7.2 system catalogs: the
array-of-timestamp-without-tz datatype is mistakenly linked to the
timestamp-with-tz element type. You can fix this with a quick UPDATE to
pg_type; in the source code the correction looks like
403c403
< DATA(insert OID = 1115 ( _timestamp PGUID -1 -1 f b t \054 0 1184 array_in array_out array_in array_out d x
_null_));
---
> DATA(insert OID = 1115 ( _timestamp PGUID -1 -1 f b t \054 0 1114 array_in array_out array_in array_out d x
_null_));
The actual SQL command to give is in the archives somewhere, if you
need more help.
regards, tom lane