Select for update is the command you are looking for.
dave
On Thu, 2003-05-29 at 08:16, dlangschied wrote:
> Hi all!
>
> I have a question that pertains to the update of records in a postgres
> database using JDBC. I extract a record from the database for update and,
> and after modification to the record, I place these changes into postgres.
> It does not look, via the documentation on JDBC, as if I have prevented
> someone from making changes at the same time. Is there a command that I
> must first perform to lock a record that is being updated? If a record is
> locked when another user wants access, what type of error information can be
> acquired to pass on to the user?
>
> Sincerely,
>
> David Langschied
> Langschied Consulting Services
> 25644 Mackinac
> Roseville, MI 48066
>
> Phone: (586)777-7542
> Cell: (248)789-8493
> e-mail: dlangschied@ameritech.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Dave Cramer <Dave@micro-automation.net>