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