From: | "Koen Antonissen" <Koen(at)Cee-Kay(dot)net> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: "posttime" time DEFAULT now() |
Date: | 2001-11-23 12:56:43 |
Message-ID: | DD782DD61CF86144BD78DDC89D3D6124017085@gaea.home.dutchcentral.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I had our sysadmin reinstall 7.1 again, we were in a hurry. Thanks for
the hint though!
Koen Antonissen
-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl(at)familyhealth(dot)com(dot)au]
Sent: vrijdag 23 november 2001 2:42
To: Koen Antonissen; pgsql-sql(at)postgresql(dot)org
Subject: RE: [SQL] "posttime" time DEFAULT now()
Try making it: "posttime" time DEFAULT 'CURRENT_TIME';
Chris
> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Koen Antonissen
> Sent: Thursday, 22 November 2001 9:30 PM
> To: pgsql-sql(at)postgresql(dot)org
> Subject: [SQL] "posttime" time DEFAULT now()
>
>
> Hi
>
> "posttime" time DEFAULT now()
>
> I'm declaring a field called posttime (see above), which ofcourse
stores
> the time of a certain posting. It's nice to use a default value as
> now(). But unfourtunatly, while creating the table, it generates the
> following error:
>
> ERROR: Column "posttime" is of type time without time zone but
default
> expression is of type timestamp with time zone
> You will need to rewrite or cast the expression
>
> I prefer to ignore the timezone information... any hints?
>
> NOTE: I've updated from 7.1 to 7.2b2 and before there was no problem
> like this (exact same table existed on 7.1).
>
>
> Thanks,
> Koen Antonissen
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aasmund Midttun Godal | 2001-11-23 14:47:23 | Re: PL/pgSQL examples NOT involving functions |
Previous Message | Johnny Jrgensen | 2001-11-23 12:49:04 | Re: How to return more than one row of data from a |