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)

-------------- 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