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
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
