On Friday 15 December 2006 07:29, Largo Stemper wrote:
> Hello Everybody
>
> That´s me again asking about how is SLONY with functions.
>
> I tested it with functions and there is a special one (the last I create)
> that can only be found only on the master. If I execute it the result will
> be transferred to the slave !
>
> I wanna know :
> - Why is this functions not replicated by slony to the slave ?
> Because I will need it  on it if I face a  FAILOVER. Here is the output and
> the function has the name largo2 , like this largo2(integer,integer)

did you use the slonik command EXECUTE SCRIPT to load the function into your 
replication set?  I'm guessing not.  Please see the slony1 admin guide 
http://www.dbitech.ca/slony/book for more information on best practices as 
well as how execute script works.



>
> -------------- On Master: --------------
>
> mydatabase2=> \df largo2
>                     List of functions
>  Schema |  Name  | Result data type | Argument data types
> --------+--------+------------------+---------------------
>  public | largo2 | numeric          | integer, integer
>
>
> -------------- On Slave: --------------
>
> mydatabase2-# \df largo2
>                    List of functions
>  Schema | Name | Result data type | Argument data types
> --------+------+------------------+---------------------
> (0 rows)
>
>
>
>  Thanks in advance
>
>
> ---------------------------------------------------------------------------
>----------------
>
> Andrew Sullivan wrote:
> > On Fri, Dec 08, 2006 at 12:20:49PM +0100, Largo Stemper wrote:
> >>  Does it represent any kind of problem if I :
> >>  - Use functions , while replicating
> >
> > No
> >
> >>  - Overwrite the functions and keep SLONY-I working
> >
> > That should be ok.
> >
> >>  - Will I get on the master (throuh replication) the new form of my
> >>  function or no?
> >
> > No.
> >
> > A
>
> _____________________________________________________________________
> Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> http://smartsurfer.web.de/?mc=100071&distributionid=000000000066
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general