[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:
BEGIN TRANSACTION;
INSERT something;
SELECT something else
END TRANSACTION;
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