Fri Oct 27 05:10:10 PDT 2006
- Previous message: [Slony1-general] Error running slony_master_setup.sh created by slony_setup.pl (Slony-I 1.1.5)
- Next message: [Slony1-general] Error running slony_master_setup.sh created by slony_setup.pl (Slony-I 1.1.5)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I got the same error and i've just replaced in the slony_setup.pl
max (usesysid) by *max (int8(usesysid)) (do it for all insert in the file)*
and all go well after !
Joost Kraaijeveld a ?crit :
> Hi,
>
> If I run slony_master_setup.sh created by slony_setup.pl (Slony-I 1.1.5)
> I get the following error:
>
> LOG: statement: insert into pg_shadow (usename, usesysid, usecreatedb,
> usesuper, usecatupd, passwd, valuntil, useconfig) values ('jkr',(select
> case when max (usesysid) + 1 < 100 then 100 else max (usesysid) + 1 end
> from pg_shadow),'t','t','t','md*********','infinity',null)
> ERROR: operator does not exist: oid + integer
> HINT: No operator matches the given name and argument type(s). You may
> need to add explicit type casts.
>
> Why is this (there is a cast from oid to int4 and int8?) and what can I
> do to correct this?
>
> TIA
>
>
- Previous message: [Slony1-general] Error running slony_master_setup.sh created by slony_setup.pl (Slony-I 1.1.5)
- Next message: [Slony1-general] Error running slony_master_setup.sh created by slony_setup.pl (Slony-I 1.1.5)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list