Postgres Pro
Downloads
Home   >   mailing lists

Re: insert blocking? - Mailing list pgsql-jdbc

From Haug Bürger
Subject Re: insert blocking?
Date
Msg-id 3CE202BA.2030706@iml.fhg.de
Whole thread Raw
In response to insert blocking?  (Haug Bürger <buerger@iml.fhg.de>)
Responses Re: insert blocking?  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-jdbc
Tree view 
Hi Dave,

from your answer i get the impression that PostgreSQL uses record
locking by default.
Do you know how to find out how the DB is configured?

Thanks
    Haug


Dave Cramer wrote:

>Haug,
>
>you will need to execute the insert within a transaction to get the
>insert to block
>
>ie:
>con.setAutoCommit(false)
>execute("begin; ___lock table___")
>executeUpdate("insert ...."
>con.commit()
>
>Dave
>

pgsql-jdbc by date:

Previous
From: Jeremy Buchmann
Date:
Subject: Re: select * from mytable where myfield=null;
Next
From: Gordon Luk
Date:
Subject: Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)