Re: Deadlock

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?
: