Re: LOCK TABLE - Mailing list pgsql-general

From K Parker
Subject Re: LOCK TABLE
Date
Msg-id IMEEMDKACADKBAAA@shared1-mail.whowhere.com
Whole thread Raw
Responses Re: Re: LOCK TABLE
List pgsql-general
Sure you can lock a single row:

   BEGIN;
   SELECT .... FOR UPDATE ... ;
   -- app messes with filesystem...
   -- may or may not actually update the row
   COMMIT;

Won't this do what you need?



Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com

pgsql-general by date:

Previous
From: "Horst Herb"
Date:
Subject: trigger inheritance
Next
From: Cristóvão Dalla Costa
Date:
Subject: Transactions aborting when a query fails