[Pgpool-general] function epoch seems to be causing error

[Andre Felipe Machado]

Hello,
I am trying to execute a query containing "epoch" and "date_part" and it seems
that it is causing trouble for pgpool 2.3.3 when inside an insert.
Directly to a backend it goes well (the web app is stable enough)
Attached is the db schema.

Please, what is the best way to isolate the problem?
Regards.
Andre Felipe




Database error: Invalid SQL: INSERT INTO
phpgw_cal(uid,title,owner,priority,is_public,category)
values('- at 127.0.0.1','teste',1003,2,1,'')
pgsql Error: -1 (ERROR: invalid input syntax for integer: "2010-08-16
14:40:35.379241-03")

File: /var/www/expresso/calendar/inc/class.socalendar_sql.inc.php
Line: 942
Function: socalendar_::save_event / socalendar::add_entry / bocalendar::update /
ExecMethod

Session halted.



snippet from the schema:

last_update    | bigint                 | default (date_part('epoch'::text,
('now'::text)::timestamp(3) with time zone) * (1000)::double precision)





-------------- next part --------------
A non-text attachment was scrubbed...
Name: expresso_schema.sql.tar.gz
Type: application/x-gzip
Size: 8431 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100816/36b7fd02/attachment.bin>