On Mon, 26 Aug 2002, Mario Weilguni wrote:
> Not a lower strength lock, I would, but I'm not so familiar with the postgres
> internals. I modified ri-triggers.c to exclude certain tables from the
> locking itself (because I know the tables are not updated).
It might help the op of this thread, s
ECTED]]
Gesendet: Montag, 26. August 2002 17:29
An: Mario Weilguni
Cc: [EMAIL PROTECTED]
Betreff: Re: [HACKERS] Deadlock situation using foreign keys
(reproduceable)
On Mon, 26 Aug 2002, Mario Weilguni wrote:
> I wrote this patch for my system, and it works fine. However, it's a
> really ugly w
On Mon, 26 Aug 2002, Mario Weilguni wrote:
> I wrote this patch for my system, and it works fine. However, it's a
> really ugly workaround. I can publish the source if anybody is
> interested.
Which, the for update one or a lower strength lock? In either case,
certainly.
I wrote this patch for my system, and it works fine. However, it's a really ugly
workaround. I can publish the source
if anybody is interested.
Am Montag, 26. August 2002 06:33 schrieb Thomas O'Dowd:
> Thanks for your feedback Stephan. Seems like a tough fix. Pitty it won't
> make it into 7.3. I
On 26 Aug 2002, Thomas O'Dowd wrote:
> Thanks for your feedback Stephan. Seems like a tough fix. Pitty it won't
> make it into 7.3. I presume there are other folk out there suffering
> from the same problems that I'm having. What approaches if any have
> people taken to work around this problem?
Thanks for your feedback Stephan. Seems like a tough fix. Pitty it won't
make it into 7.3. I presume there are other folk out there suffering
from the same problems that I'm having. What approaches if any have
people taken to work around this problem? I read in the list that one
user patched his p
On 26 Aug 2002, Thomas O'Dowd wrote:
> Hi all,
>
> I've been having a lot of trouble with deadlocks in 7.2.1 because of
> foreign keys. I dug out a couple of messages from the list archives
> which cover this topic.
>
> One particular message indicates a fix was being worked on.
>
> Dat
Hi all,
I've been having a lot of trouble with deadlocks in 7.2.1 because of
foreign keys. I dug out a couple of messages from the list archives
which cover this topic.
One particular message indicates a fix was being worked on.
Date: Thu, 11 Apr 2002 09:03:06 -0700 (PDT)
From: Stephan
On Thu, 11 Apr 2002, Mario Weilguni wrote:
> As promised here's an example of deadlock using foreign keys.
>
> create table lang (
> id integer not null primary key,
> name text
> );
> insert into lang values (1, 'English');
> insert into lang values (2, 'German');
>
> create table country (
As promised here's an example of deadlock using foreign keys.
create table lang (
id integer not null primary key,
name text
);
insert into lang values (1, 'English');
insert into lang values (2, 'German');
create table country (
id integer not null primary key,
name text
);
insert into
10 matches
Mail list logo
