Donald Fraser (demolish(at)gtonline(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.
timestamp is converted to timestamptz
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 that I 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 backend system. That is DATETIME is not available as a column data type.
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Dmitry Tkach||Date: 2002-07-23 16:55:33|
|Subject: JDBC timestamp does not understand [-]infinity|
|Previous:||From: Scott Shattuck||Date: 2002-07-23 15:00:17|
|Subject: Re: VACUUM FULL changes the order of rows in a table?|