[Pgpool-general] PGPOOL-II and FUNCTIONS

[Tatsuo Ishii]

> Thanks for your answer Tatsou.
> 
> I think that there's a bug in the replicate_select function in pgpool-ii
> v2.0.1

Can you give more details?

> I was trying with pgpool 3.4.1 (pgpool-i) and it works. However I think that
> pgpool-ii is great! what version can you advice me try??

That's because pgpool-i works as if replicate_select is always true.

Can you grab pgpool-II CVS Head and try it out?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Best Regards,
> 
> Luis Alberto Perez Paz
> 
> 
> 
> On Sun, Mar 9, 2008 at 5:50 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> > > Hi everybody,
> > >
> > > Is possible with pgpool-ii (in replication mode) make replication of
> > called
> > > to functions??
> > >
> > > I mean:
> > >
> > >                                                           ----> psql1
> > >
> > [select
> > > myfunction();]
> > >          client              -------->  pgpool   ----> psql2
> > > [select myfunction();]                                [select
> > myfunction();]
> > >                                                           ----> psql3
> > >
> > [select
> > > myfunction();]
> >
> > Sure.
> >
> > load_balance_mode = false
> > replicate_select = true
> >
> > will do the trick.
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> >
> 
> 
> 
> -- 
> paz, amor y comprensión
>        (1967-1994)