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

[Tatsuo Ishii]

Looking into this now. Pgpool-II is not very smart in rewriting
complex default values. I think you hit the case. Let me think about
work arounds for this...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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)
> 
> 
> 
> 
>