Vick Khera wrote:
On Thu, Dec 3, 2009 at 5:15 AM, Glyn Astill <[email protected]> wrote:
I took a quick peek in slony1_funcs.sql from the 1.2.18 release and the
drop_if_exists functionality appears to be in there (although not in the
slony1_funcs.vNN.sql scripts). I'm going to do a few more tests before
upgrading our servers...
Once I added the lines
drop function if exists @[email protected]_complete (int4, text, int4);
drop function if exists @[email protected] (int4, int4);
to slony1_funcs.sql it as was installed, my update succeeded.
That is only OK in newer versions... "drop function if exists" doesn't
work on 7.4, for instance.
I took a look in the released code, and it seems like it has the
function I added to emulate this:
ch...@dba2:builds/slony1-1.2.18/src/backend> grep -n drop_if
slony1_funcs.sql
3761:create or replace function @[email protected]_if_exists (text, text)
returns integer as '
3775:comment on function @[email protected]_if_exists (text,text) is
'Emulate DROP FUNCTION IF EXISTS, which does not exist in 7.4, 8.0, 8.1';
3777:select @[email protected]_if_exists ('ddlscript_complete', 'int4,
text, int4');
5457:select @[email protected]_if_exists ('updatereloid', 'int4, int4');
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
