Обсуждение: Bug #717: timestamp is converted to timestamptz

Donald Fraser (demolish@gtonline.net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
timestamp is converted to timestamptz

Long Description
When specifying a column data type as timestamp it is always converted to timestamptz.
According to the documentation on types, there is a difference between timestamp and timestampz, yet the only place
thatI can find documentation that says timestamp will be converted to timestamptz is in the source code (gram.y).
 
As a work around I found that using the ANSI SQL DATETIME type, it is converted to type timestamp.
The annoyance is that progams such as pgAdminII only allow you to specify column data types for those specified by the
backendsystem. That is DATETIME is not available as a column data type. 

Sample Code


No file was uploaded with this report

...
> When specifying a column data type as timestamp it is always converted to timestamptz.

That is true for 7.2.x and earlier, but 7.3 will have the defaults
reversed.

In the meantime, use explicit WITH TIME ZONE and WITHOUT TIME ZONE
clauses on the declaration.

                   - Thomas