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('[email protected]','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)
expresso_schema.sql.tar.gz
Description: GNU Zip compressed data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
