Joost Kraaijeveld J.Kraaijeveld
Fri Oct 27 04:55:49 PDT 2006
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

-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl



More information about the Slony1-general mailing list