[OT] SQL question

[Dr. Hawkins]

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