[OT] SQL question

Malte Brill revolution at derbrill.de
Mon Nov 11 09:26:14 EST 2013


Hi all, 

thanks for giving some thought. After more lost hair, this appears to work:

INSERT INTO test2 (id,UUID,nummer) VALUES (3,1,(SELECT MAX(value) FROM (SELECT erste_nummer AS VALUE FROM test1 WHERE test1.UUID='1' UNION SELECT max(nummer) AS VALUE FROM test2 where test2.UUID='1') AS t1)+1)

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.

All the best,

Malte





More information about the Use-livecode mailing list