Re: Deadlock

Yes. Also, I have about 65 tables and i never get a deadlock anywhere else, just here. However, this tables is accessed for almost 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(at)megazone23(dot)bigpanda(dot)com>
To: "Nikhil G. Daddikar" <ngd(at)celoxis(dot)com>
Cc: "pggeneral" <pgsql-general(at)postgresql(dot)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?
: