Vick Khera vivek at khera.org
Thu Dec 3 13:46:04 PST 2009
> 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.


More information about the Slony1-general mailing list