Skip site navigation (1) Skip section navigation (2)

Re: Help-PGRES_FATAL_ERROR

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: John Carriel Gomez <john(dot)carriel(dot)g(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Help-PGRES_FATAL_ERROR
Date: 2011-08-08 03:36:25
Message-ID: CAJKUy5iZnA36sA2GtVS3az90vEepsALATj_n_NqY1tOt8WM0wg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sun, Aug 7, 2011 at 3:10 PM, John Carriel Gomez
<john(dot)carriel(dot)g(at)gmail(dot)com> wrote:
> Please help I can not replicate with Slony
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> PGRES_FATAL_ERROR select "_replicaterminal".storeNode_int(1, 'Nodo
> Maestro'); select "_replicaterminal".enableNode_int(1);  - ERROR:  invalid
> input syntax for type timestamp: "Sun Aug 07 14:59:30.073665 2011 ECT"
> CONTEXT:  SQL statement "insert into "_replicaterminal".sl_confirm
>                         (con_origin, con_received, con_seqno)
>                         select no_id, p_no_id, 0 from
> "_replicaterminal".sl_node
>                                 where no_id != p_no_id
>                                 and no_active"
> PL/pgSQL function "enablenode_int" line 32 at SQL statement
>

what do you have in timezone in postgresql.conf? certainly, the
timestamp format looks odd

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to

Responses

pgsql-bugs by date

Next:From: listarDate: 2011-08-08 13:13:33
Subject: BUG #6154: wrong result with nested left-joins
Previous:From: John Carriel GomezDate: 2011-08-07 20:10:33
Subject: Help-PGRES_FATAL_ERROR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group