[Pgpool-hackers] Idea to handle sequences

Jaime Casanova jaime at 2ndquadrant.com
Sat Jan 8 01:02:12 UTC 2011


On Fri, Jan 7, 2011 at 5:46 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
> On master we do:
>
> BEGIN;
> SELECT 1 FROM t1_i_seq FOR UPDATE;

and why you are allowed to execute FOR UPDATE in a sequence? i mean,
if you can't lock the secuence it has no sense that you can lock the
rows on it... is it not a postgres bug that we should report instead
of exploit it?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL


More information about the Pgpool-hackers mailing list