471,073 Members | 1,305 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

default value problem in postgresql 7.4.5-2

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
fr**********@gmail.com

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

Nov 23 '05 #1
1 2439
Frans <fr**********@gmail.com> writes:
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


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 ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by akl | last post: by
8 posts views Thread by Lars Kellogg-Stedman | last post: by
10 posts views Thread by Brad Baker | last post: by
4 posts views Thread by Macneed | last post: by
43 posts views Thread by kenneth | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.