Problem wil TIMEZONE vs TIME ZONE

From: Mike Wes <mikeewes(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problem wil TIMEZONE vs TIME ZONE
Date: 2017-02-08 11:20:35
Message-ID: CAPLgiTOV3CaBRsBjW_uY+T52qb6kEqW29AL85wFhSC3HHuMh7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good day,

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?

DROP TABLE IF EXISTS "public"."giant_log2";
CREATE TABLE "public"."giant_log2" (
"id" int8 NOT NULL,
"version" int8,
"uid" varchar(40) COLLATE "default",
"consumer_id" varchar(20) COLLATE "default",
"customer_id" varchar(20) COLLATE "default",
"provider_id" varchar(15) COLLATE "default",
"company_id" varchar(60) COLLATE "default",
"country_code" varchar(2) COLLATE "default",
"type_of_operation" varchar(40) COLLATE "default",
"log_created" timestamp WITH TIME ZONE,
"adapter_component" varchar(20) COLLATE "default",
"order_status" varchar(20) COLLATE "default",
"reference_nr" varchar(100) COLLATE "default",
"xml_data" text COLLATE "default"
)
WITH (OIDS=FALSE);
ALTER TABLE "public"."giant_log2" OWNER TO "giant";

DROP TABLE IF EXISTS "public"."giant_log3";
CREATE TABLE public.giant_log3 (id BIGINT NOT NULL,
version BIGINT,
uid VARCHAR(40),
consumer_id VARCHAR(20),
customer_id VARCHAR(20),
provider_id VARCHAR(15),
company_id VARCHAR(60),
country_code VARCHAR(2),
type_of_operation VARCHAR(40),
log_created TIMESTAMP WITH TIMEZONE,
adapter_component VARCHAR(20),
order_status VARCHAR(20),
reference_nr VARCHAR(100),
xml_data TEXT,
CONSTRAINT common_giant_log_pkey PRIMARY KEY (id))
WITH (OIDS=FALSE);
ALTER TABLE "public"."giant_log3" OWNER TO "giant";

Kind regards,

Mike

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2017-02-08 14:32:39 Re: Problem wil TIMEZONE vs TIME ZONE
Previous Message Herwig Goemans 2017-02-08 10:20:14 Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.