Re: insert blocking?

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
>