Fri Dec 15 07:29:11 PST 2006
- Previous message: [Slony1-general] CVS execute script
- Next message: [Slony1-general] "CREATE OR REPLACE function ..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] CVS execute script
- Next message: [Slony1-general] "CREATE OR REPLACE function ..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list