On Sat, 8 Mar 2003, A.Bhuvaneswaran wrote:
>
> > > Can you able to give some test cases? Here i have tried, but unable to
> > > detect deadlock.
> >
> > Not a complete or tested example, but:
> > create table a (a int primary key);
> > create table b ( b int references a);
> > insert into a value
> > Can you able to give some test cases? Here i have tried, but unable to
> > detect deadlock.
>
> Not a complete or tested example, but:
> create table a (a int primary key);
> create table b ( b int references a);
> insert into a values (1);
> insert into a values (2);
> Transaction 1: begin;
On Fri, 7 Mar 2003, A.Bhuvaneswaran wrote:
>
> > If you're using foreign keys on the table that you're inserting into it's
> > possible that it's waiting on another transaction doing an insert to the
> > same key or on a change to the referenced table.
>
> Can you able to give some test cases? He
> If you're using foreign keys on the table that you're inserting into it's
> possible that it's waiting on another transaction doing an insert to the
> same key or on a change to the referenced table.
Can you able to give some test cases? Here i have tried, but unable to
detect deadlock.
BTW
On Thu, 6 Mar 2003, A.Bhuvaneswaran wrote:
> Hi,
>
> I am using pgsql 7.2.3 on redhat linux 7.3.
>
> I am facing the deadlock detected error in transaction during insert
> command. How can i fix this?
If you're using foreign keys on the table that you're inserting into it's
possible that it's wa
