Andrew Sullivan wrote:
> On Thu, Jun 29, 2006 at 10:41:47AM -0400, Sean Kirkpatrick wrote:
>   
>> I've been successfully using slony (1.0.5) to replicate several
>> 7.4.6 databases to various numbers of nodes for about 6 months now,
>>     
>
> Off-topic, but you are aware that 7.4.6 is a _long_ way back in the
> minor release chain, right?  You want to upgrade that really soon.
>
>   
>> ERROR  remoteWorkerThread_1: copy from stdin on local node - PGRES_FATAL_ERROR ERROR:  invalid input syntax fo
>> r integer: "t"
>> CONTEXT:  COPY tlcalerttbl, line 1, column marketstate: "t"
>>
>> It appears that the column values are misaligned somewhere in the
>> copy.  This isn't the table that the primary key was changed on
>> either.
>>     
>
> I think you need to re-build the schema on the remote system.  I
> forget which version introduced column names in the COPY command, but
> that would also help you (and you wouldn't need the schema rebuild).
>
> A
>   
Column names entered somewhere in 1.1.  I sorta think 1.1.1, not that
that was a particularly wonderful version :-(.

At any rate, I'd be more concerned about using the ancient version of
Slony-I than about the age of the PG version...