[pgpool-general: 4035] Re: Postgres Sequence numbers different on backends when inserts run concurrently

[Yugo Nagata]

Hi,

I'm sorry for not informing you of the patch.
The patch for 3.3.x is available from 'patch' link in the following page.

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=e5509d227cef65c55f0bd018e995d7ea7a5dcf68

Regards,

Yugo


On Thu, 03 Sep 2015 08:57:02 -0400
Steve Kuekes <steve.kuekes at physicianspharmacy.com> wrote:

> Is there an update on this patch availability.
> 
> Steve
> 
> On 07/30/2015 04:15 AM, Yugo Nagata wrote:
> > On Tue, 28 Jul 2015 13:40:14 +0900
> > Yugo Nagata <nagata at sraoss.co.jp> wrote:
> >> I'll look into this and fix it.
> > I found that insert-lock never be issued at 3.4.3. The problem is
> > the following commit:
> >
> > "Fix the case when user table includes spaces"
> > http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6a7b1ff4eb1cf0fba16ff3ca909a1505355b05ae
> >
> > Due to this, table names passed to pgpool_regclass are double-quoted
> > and pgpool_regclass('"public.my_table"') always returns null. Instead,
> > it should be pgool_regclass('"public"."my_table"').
> >
> > This causes pgpool-II to fail to check needs for insert_lock properly.
> >
> > I'll make a patch for fixing it.
> >
> 
> -- 
> Steve Kuekes
> 
> Physicians Pharmacy Alliance
> 118 MacKenan Drive, Suite 200
> Cary, NC  27511
> 919-465-5801 direct
> 919-463-5555 main
> 919-463-5566 fax
> 
> steve.kuekes at physicianspharmacy.com
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>