> On Fri, Jan 7, 2011 at 5:46 AM, Tatsuo Ishii <[email protected]> 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?
Not sure I want to report it. The "bug" does not hurt PostgreSQL users in any sense, for example security issues. Theoreticaly we could fix this "bug" and provide "formal" way to lock sequences instead. But I doubt PostgreSQL cores agree to provide such new API, which is probably only benefitical to pgpool users. So I guess reporting the "bug" and fixing it will not benefit anyone, on the other hand pgpool users will lose their benefit. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
