Radicore Forum: How To » setting default values for created_date and updated

Home » RADICORE » How To » setting default values for created_date and updated_date (RADICORE doesn't seem to like it when you do this...)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

setting default values for created_date and updated_date [message #4972]

Wed, 02 September 2015 01:24

rafs
Messages: 69
Registered: May 2015

Member

I set default values for my created_date and updated_date values in PGSQL: DEFAULT 'now'::text::timestamp without time zone
RADICORE imported the word 'now' in the field upon 'import columns' action.
This causes an error warning when you try to create a new record in that table.
I just removed an default.
Just posting in case somebody runs into an error like this.

Report message to a moderator

Re: setting default values for created_date and updated_date [message #4983 is a reply to message #4972]

Wed, 02 September 2015 11:30

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

Firstly, the correct value for that default would be "now()" as any word followed by "(...)" is treated as a function. 'now' in quotes is treated as a string and is totally invalid for a field which is supposed to hold a timestamp.

Secondly, you should remove "now()" from the default value in the Data Dictionary and set the "Auto Insert" property instead.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Setting PK field to NOEDIT, but not NOSEARCH
Next Topic:	Cancel a Generate PHP screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 01:19:42 EST 2024

Total time taken to generate the page: 0.00942 seconds