default value problem in postgresql 7.4.5-2

[Frans]

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'::time stamp without time zone
I've tried to erase the "::timestam p 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@gm ail.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Re: default value problem in postgresql 7.4.5-2

Frans <fransgunawan@g mail.com> writes:[color=blue]
> I set the default value to '1900-01-01 00:00:00' , but the result is
> '1900-01-01 00:00:00'::time stamp without time zone[/color]

Why is this a problem?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly