Thu Dec 3 13:46:04 PST 2009
- Previous message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Next message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> I took a look in the released code, and it seems like it has the function I > added to emulate this: > > chris at dba2:builds/slony1-1.2.18/src/backend> grep -n drop_if > slony1_funcs.sql > 3761:create or replace function @NAMESPACE at .drop_if_exists (text, text) > returns integer as ' > 3775:comment on function @NAMESPACE at .drop_if_exists (text,text) is 'Emulate > DROP FUNCTION IF EXISTS, which does not exist in 7.4, 8.0, 8.1'; > 3777:select @NAMESPACE at .drop_if_exists ('ddlscript_complete', 'int4, text, > int4'); > 5457:select @NAMESPACE at .drop_if_exists ('updatereloid', 'int4, int4'); > > Yep, it is there... but the ddlScript_complete() function does not get dropped by it, at least in 8.3, in each of the three replications I have running. I'll do some more testing with upgrading from 1.2.16 to 1.2.18.
- Previous message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Next message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list