Re: insert blocking?

From: Haug Bürger <buerger(at)iml(dot)fhg(dot)de>
To: postgres <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: insert blocking?
Date: 2002-05-15 06:39:54
Message-ID: 3CE202BA.2030706@iml.fhg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gordon Luk 2002-05-15 08:27:06 Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)
Previous Message Andrew Sullivan 2002-05-14 19:57:47 Re: [JDBC] select * from mytable where myfield=null;