Re: what could be blocking an insertion? - Mailing list pgsql-general

From Sascha Bohnenkamp
Subject Re: what could be blocking an insertion?
Date
Msg-id 5p8c2tFpre14U1@mid.individual.net
Whole thread Raw
In response to what could be blocking an insertion?  (Kent Tong <kent@cpttm.org.mo>)
List pgsql-general
> There were other JDBC clients but they never
> lock any tables. They all used transactions with the serializable isolation level.

If you have concurrent access and some isolation you have locking.
If two inserts/updates try to change the same data (even via
triggers/rules) you get a failed commit.

maybe tis helps

pgsql-general by date:

Previous
From: Abandoned
Date:
Subject: Re: Copy the database..
Next
From: Bill Moran
Date:
Subject: Re: Postgresql simple query performance question