On Mon, 2009-12-28 at 15:51 +0000, Tam McLaughlin wrote:
> Thanks for the reply.
> 
> I agree that this number is very large, but it is not my number!
> I don't know where it comes from?
> It seems to be something slony has generated.


There was an issue fixed a few months ago in the 1.2 branch with a data
type mismatch between the slon (bigint) and the DB (int).  This looks to
be a similar issue.

> On Mon, Dec 28, 2009 at 3:40 PM, Andrew Sullivan <ajs at crankycanuck.ca>
> wrote:
>         On Wed, Dec 23, 2009 at 01:52:13PM +0000, Tam McLaughlin
>         wrote:
>         > slony: 2.0.3 rc3
>         > Postgresql: 8.3.3
>         > Centos: 5.2
>         >
>         > When I add a new table using "excute script" I get the
>         following error:
>         >
>         > Submit DDL Event to subscribers...
>         > <stdin>:6: PGRES_FATAL_ERROR select
>         "_mesrep".ddlScript_complete(1,
>         > $1::text, -1);  - ERROR:  value "5000012320" is out of range
>         for type
>         > integer
>         
>         
>         My guess is that you're trying to number a table with too high
>         a
>         value.  Integers only hold 4 billion, and your proposed id
>         there looks
>         like 5 billion unless I'm counting places wrong.
>         
>         A
>         
>         
>         
>         --
>         Andrew Sullivan
>         ajs at crankycanuck.ca
>         _______________________________________________
>         Slony1-general mailing list
>         Slony1-general at lists.slony.info
>         http://lists.slony.info/mailman/listinfo/slony1-general
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.