On Mon, 2011-01-03 at 18:08 +0200, Heikki Linnakangas wrote: > It works in read committed mode, because you acquire a new snapshot > after the LOCK TABLE, and anyone else who modified the table must commit > before the lock is granted. In serializable mode you get a serialization > error.
If its not safe without this LOCK TABLE ... IN SHARE ROW EXCLUSIVE MODE then we should do that automatically, and document that. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers