current_timestamp without TZ in CREATE table

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: current_timestamp without TZ in CREATE table
Date: 2002-12-17 07:04:24
Message-ID: 3DFECC78.5080108@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get the following error while trying to create a table:

JC=# create table test (t timestamp[0] default current_timestamp(0));
ERROR: Column "t" is of type timestamp without time zone[] but default
expression is of type timestamp with time zone You will need to rewrite
or cast the expression

What is the proper syntax to declare the default to be without time zone?

Thanks,

JC

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-17 07:24:51 Re: current_timestamp without TZ in CREATE table
Previous Message Martijn van Oosterhout 2002-12-17 05:57:44 Re: How to access deleted but not vacuum'ed tuples?