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


-- 
Andrew Sullivan  | ajs at crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful 
than reformatting your hard drive when it gets out of whack.
		--Scott Morris