Re: [SQL] Which SQL command creates ExclusiveLock?

2004-04-27 Thread Tom Lane
Denis Khabas [EMAIL PROTECTED] writes: According to postgres documentation, all update operations place ROW EXCLUS= IVE MODE locks, and=20 EXCLUSIVE MODE is not automatically acquired by any postgres SQL command. S= o, which command places ExclusiveLock? It says that no SQL command acquires

[SQL] Which SQL command creates ExclusiveLock?

2004-04-26 Thread Denis Khabas
Hi everyone! I have a web application that uses Postgresql on backend. The application performs selects, updates, inserts, and deletes by using Hibernate. Tables contain indexed fields. When I run the following query, SELECT * FROM pg_locks, it shows that some transactions place