Try making it: "posttime" time DEFAULT 'CURRENT_TIME';
Chris
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Koen Antonissen
> Sent: Thursday, 22 November 2001 9:30 PM
> To: pgsql-sql@postgresql.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@postgresql.org
>
