Re: Deadlock
От | Nikhil G. Daddikar |
---|---|
Тема | Re: Deadlock |
Дата | |
Msg-id | 001d01c26c1f$17d5aaa0$2c00a8c0@darkstar обсуждение исходный текст |
Ответ на | Re: Deadlock (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Список | pgsql-general |
Yes. Also, I have about 65 tables and i never get a deadlock anywhere else, just here. However, this tables is accessed foralmost all operation (read-mode) since all pages require security checks. create table db_security_desc ( id integer primary key, vdb_id integer, ts timestamp not null, object_id integer not null, object_type integer not null, strid varchar(100) not null, company_id integer not null references db_company(id), acl_id integer not null UNIQUE, is_n_on_no_match char(1) not null, is_n_on_conflict char(1) not null, unique(object_id, object_type, company_id), unique(strid, company_id) ); ----- Original Message ----- From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com> To: "Nikhil G. Daddikar" <ngd@celoxis.com> Cc: "pggeneral" <pgsql-general@postgresql.org> Sent: Friday, October 04, 2002 9:10 PM Subject: Re: [GENERAL] Deadlock : On Thu, 3 Oct 2002, Nikhil G. Daddikar wrote: : : > While updating database (7.1.3) thro' JDBC I get a deadlock error : : > : > Exception Message: ERROR: Deadlock detected. : > See the lock(l) manual page for a possible cause. : : Are you using any foreign keys to or from this table? :
В списке pgsql-general по дате отправления: