Re: [HACKERS] deadlock problems with foreign keys

2002-03-28 Thread Jan Wieck
Jan > > > -- > Rod Taylor > > This message represents the official view of the voices in my head > > - Original Message - > From: "Mario Weilguni" <[EMAIL PROTECTED]> > To: "Postgresql Mailinglist (E-Mail)" <[EMAIL PROTECTED]&g

Re: [HACKERS] deadlock problems with foreign keys

2002-03-28 Thread Mario Weilguni
to trigger with more tables. I'll try to create a testcase and post it. -Ursprüngliche Nachricht- Von: Rod Taylor [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 28. März 2002 16:15 An: Mario Weilguni; Hackers List Betreff: Re: [HACKERS] deadlock problems with foreign keys There wa

Re: [HACKERS] deadlock problems with foreign keys

2002-03-28 Thread Jan Wieck
Mario Weilguni wrote: > I've a severe problem with deadlocks in postgres, when using referential integrity >it's quite easy to trigger deadlocks. I think the may be a bug in ri_trigger.c >(discussed later). Here's some short example: > > create table languages ( > idinteger not null, >

Re: [HACKERS] deadlock problems with foreign keys

2002-03-28 Thread Rod Taylor
sage represents the official view of the voices in my head - Original Message - From: "Mario Weilguni" <[EMAIL PROTECTED]> To: "Postgresql Mailinglist (E-Mail)" <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 9:44 AM Subject: [HACKERS] deadlock problems wi

[HACKERS] deadlock problems with foreign keys

2002-03-28 Thread Mario Weilguni
I've a severe problem with deadlocks in postgres, when using referential integrity it's quite easy to trigger deadlocks. I think the may be a bug in ri_trigger.c (discussed later). Here's some short example: create table languages ( idinteger not null, name textnot null,