agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Wes <mikeewes@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem wil TIMEZONE vs TIME ZONE
Date: Wed, 08 Feb 2017 10:52:38 -0500
Message-ID: <1471.1486569158@sss.pgh.pa.us> (raw)
In-Reply-To: <CAPLgiTOV3CaBRsBjW_uY+T52qb6kEqW29AL85wFhSC3HHuMh7g@mail.gmail.com>
References: <CAPLgiTOV3CaBRsBjW_uY+T52qb6kEqW29AL85wFhSC3HHuMh7g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

Mike Wes <mikeewes@gmail.com> writes:
> Can anybody clarify the following behaviour of pgsql? A Windows user in our
> project is not able to execute a create table command caused by the
> timestamp field log_created using 'TIME ZONE' (giant_log2), but must
> explict use 'TIMEZONE' (giant_log3). This is an issue while we use
> liquibase in our project. Any ideas why this is happening?

That sounds quite backwards.  TIMESTAMP WITH TIME ZONE is the SQL-standard
way of spelling the type name.  TIMESTAMP WITH TIMEZONE is not in the
standard and it's not accepted by Postgres either, as you can easily
prove by experiment:

regression=# create table foo(f1 TIMESTAMP WITH TIMEZONE);
ERROR:  syntax error at or near "WITH"
LINE 1: create table foo(f1 TIMESTAMP WITH TIMEZONE);
                                      ^
regression=# create table foo(f1 TIMESTAMP WITH TIME ZONE);
CREATE TABLE

I think you must've had some confusion as to who issued which
command.

			regards, tom lane


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (3+ messages)

Message-ID: <1471.1486569158@sss.pgh.pa.us>
Permalink:  ../1471.1486569158@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1471.1486569158@sss.pgh.pa.us

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mikeewes@gmail.com
  Subject: Re: Problem wil TIMEZONE vs TIME ZONE
  In-Reply-To: <1471.1486569158@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox