[OT] SQL question
dochawk at gmail.com
Mon Nov 11 11:14:29 EST 2013
On Mon, Nov 11, 2013 at 6:26 AM, Malte Brill <revolution at derbrill.de> wrote:
> The Problem is, that postGreSQL appears to be locking tables only during
> the transaction and automagically releases the lock, which is not ideal in
> my situation.
You can use a begin/end lock to get everything done:
SELECT something else
and either the whole block happens, or the db is untouched.
You could also make the column a serial or auto-incrementing key.
Dr. Richard E. Hawkins, Esq.
More information about the Use-livecode