Re: insert blocking?

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

On Mon, 2002-05-13 at 05:36, Haug Bürger wrote:
> Hi,
>
> i use a prepared statement to insert a new record. Is it possible
> that an insert blocks? In other words can the
> myInsertStmt.executeUpdate() call block?
>
> thanks
>     Haug
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>