Problems with timestamp in cakephp 1.3 and postgresql 9

I am new to cakephp and have tried to install on Vista with WAPP from
bitnami. I succeeded in making it run, but is having problem with the
datatype for created and modified. Have tried all dateformat provided
by postgesql, but gets an error message. If I change to character var
it is OK, but then it is not timestamp.

This is the query:
Query: INSERT INTO "cakes" ("user_id", "cakename", "modified",
"created") VALUES ('4ceacf69-1bcc-4a43-93cb-0970a4d2bb16', 'testcake',
'\\x323031302d31312d3233', '\\x323031302d31312d3233')

and I get this two errormessages.

Warning (2): pg_query() [function.pg-query]: Query failed: ERROR:
invalid input syntax for type date: "\x323031302d31312d3233"
LINE 1: ...ceacf69-1bcc-4a43-93cb-0970a4d2bb16', 'testcake', '\
\x323031...
^ [CORE
\cake\libs\model\datasources\dbo\dbo_postgres.php, line 167]

Warning (512): SQL Error: ERROR: invalid input syntax for type date:
"\x323031302d31312d3233"
LINE 1: ...ceacf69-1bcc-4a43-93cb-0970a4d2bb16', 'testcake', '\
\x323031...
^ [CORE
\cake\libs\model\datasources\dbo_source.php, line 681]

I have searched at internet, but have not found any solution. I have
tried to insert data in the tables using phppgadmin. If i replace \
\x323031302d31312d3233 with '2011-12-11 21:12:11' it is stored
correctly.

I have used the bake functionality and have not written the php code
myself. Is it a common problem that cakephp and postgresql dows not
works wells together.

Erik

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en