default value problem in postgresql 7.4.5-2

From: Frans <fransgunawan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: default value problem in postgresql 7.4.5-2
Date: 2004-09-24 05:16:37
Message-ID: e07d6ffa04092322162de75d6e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have just upgrade my postgresql to 7.4.5-2, but I have problem with
default value in postgresql 7.4.5-2, everytime I set default value for
varchar or timestamp fields, the result value always change to
sometihing like this :
I set the default value to '1900-01-01 00:00:00' , but the result is
'1900-01-01 00:00:00'::timestamp without time zone
I've tried to erase the "::timestamp withut time zone" but it didn't work.

this problem never occurs in postgresql 7.3.4.

Is there any solusion for my problem?

thanks....

--
Best Regards,

Frans Gunawan
fransgunawan(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-24 05:38:22 Re: default value problem in postgresql 7.4.5-2
Previous Message Bill Harris 2004-09-24 04:30:38 Re: data modeler