| From: | "Vit Timchishin" <tivv(at)gtech-ua(dot)com> |
|---|---|
| To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | More about deadlock |
| Date: | 2005-12-06 12:20:50 |
| Message-ID: | 200512061420.000000EL@dev-null |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hello.
I've now got more details on my deadlock. Here is what I have at the time it occurs:
umh=# select * from pg_locks where transaction=1119237;
relation | database | transaction | pid | mode | granted
----------+----------+-------------+-------+---------------+---------
| | 1119237 | 18880 | ShareLock | f
| | 1119237 | 18404 | ExclusiveLock | t
(2 rows)
Can anyone tell me what are this "transaction" locks, when they are taken and why do I have a deadlock
here.
С уважением,
Виталий Валериевич Тимчишин,
Технический Директор
ООО "Голден Технолоджис"
http://www.gtech-ua.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-12-06 12:52:54 | Re: Problem with 8.1 driver |
| Previous Message | Tea Yu | 2005-12-06 10:45:21 | Re: JDBC executeUpdate returns 0 for table partitioning rule insertion |