Fri Oct 23 07:10:54 PDT 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 ]
On Oct 21, 2009, at 8:55 AM, Christopher Browne wrote: > The following patch should rectify this... > > Index: slony1_funcs.sql > =================================================================== > RCS file: /home/cvsd/slony1/slony1-engine/src/backend/ > slony1_funcs.sql,v > retrieving revision 1.145.2.19 > diff -c -u -r1.145.2.19 slony1_funcs.sql > cvs diff: conflicting specifications of output style > --- slony1_funcs.sql 23 Sep 2009 16:14:32 -0000 1.145.2.19 > +++ slony1_funcs.sql 21 Oct 2009 12:32:57 -0000 > @@ -3643,6 +3643,8 @@ > -- > -- Generate the DDL_SCRIPT event > -- > ---------------------------------------------------------------------- > +drop function if exists @NAMESPACE at .ddlScript_complete (int4, text, > int4); -- Needed because function signature has changed! > + > create or replace function @NAMESPACE at .ddlScript_complete (int4, > text, int4) > returns bigint > as $$ > @@ -5063,6 +5065,7 @@ > -- > -- Reset the relnames > -- > ---------------------------------------------------------------------- > +drop function if exists @NAMESPACE at .updateReloid (int4, int4); > create or replace function @NAMESPACE at .updateReloid (int4, int4) > returns bigint > as $$ > > That's working and committed to 2.0 + HEAD. > This works for me. My origin is 8.2, slave is 8.4 (preparing for an upgrade! wheeee!) It was a bit surprising this slipped through. -- Jeff Trout <jeff at jefftrout.com> http://www.stuarthamm.net/ http://www.dellsmartexitin.com/
- 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