On Tue, 2007-01-09 at 16:47 +0100, Largo Stemper wrote:
> 
>  Hi everybody and HAPPY NEW YEAR
>  
> 
>  I wanna know why are some of my functions not replicated like the rest of my database.
>  
>  I used to replicate my DB from my Master to my slave using the slonik commands and SLON.
>  
>  I see that everything was replicated except "SOME" of my functions , not all. I did test lot of scenarios but nothing works.
>  
>  So please :
>  
>  - What are the conditions that prevents a funcitons from being replicated ?

Slony uses triggers to replicate data.  You can't define a trigger on a
function.

>  - The replication is running : Can I see my functions on my slave if I create them on the master with the psql-Client and (/i myFunction.sql) ?

What you want to do is create the functions via psql on all of the
databases that you are replicating.

>  - Even EXECUTE SCRIPT on the slonik script did not help, it creates my function only on the master, what is if I have a Failover ??

Did you execute the script only on the master?  Did you get any errors
in your slon log, or in the postgres logs on the subscriber?

>  - Is it  the same for TRIGGERs

Sort of.  Triggers won't be replicated.  When you add them, you need to
do it with a slonik EXECUTE script.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.