On 8/18/2010 9:40 PM, Christopher Browne wrote:
> Where Jan's leaning comes in the comment here:
> ------
> To fix this, slonik needs to issue LOCK TABLE statements right after "begin;".
> That way, it will wait until all conflicting transactions have committed before
> generating its own snapshot.
> 
> We need new syntax to add this information to the EXECUTE SCRIPT command and it
> will be the responsibility of the user to provide the list of tables to lock.

An alternative to this would be to have EXECUTE SCRIPT parse the DDL 
script a little deeper, executing all LOCK TABLE statements at the 
beginning, before creating the SYNC that contains all DML before the DDL.

This way we would not need to change the EXECUTE SCRIPT syntax at all.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin