[OT] SQL question

Dr. Hawkins 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:

       INSERT something;
       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.
(702) 508-8462

More information about the Use-livecode mailing list