Re: argtype_inherit() is dead code - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: argtype_inherit() is dead code
Date
Msg-id 1113783329.3859.444.camel@home
Whole thread Raw
In response to Re: argtype_inherit() is dead code  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
On Sun, 2005-04-17 at 19:54 -0400, Robert Treat wrote:
> On Sunday 17 April 2005 19:30, Rod Taylor wrote:
> > On Sun, 2005-04-17 at 14:04 -0400, Alvaro Herrera wrote:
> > > On Sun, Apr 17, 2005 at 06:56:01AM -0700, Joshua D. Drake wrote:
> > > > From a "people who call me" perspective. I am never asked about
> > > > inheritance. Most of the people don't even know it is there.
> > > > The requests I get are:
> > >
> > > Just wondering, does anybody asks you about the excessive locking (and
> > > deadlocking) on foreign keys?  The business about being able to drop
> > > users and then find out they were still owners of something?  I guess I
> > > worry about things too low-level that nobody really cares too much about.
> >
> > I know of plenty of people impacted by foreign key locking that remove
> > specific keys in production that they have in place for testing.
> >
> 
> That or put calls into try/catch mechanisms "just in case" it deadlocks even 
> though it wouldn't with some less restrictive locking mechanism.  Or come up 
> with some type of serializing scheme to ensure deadlocks can't happen.  Or 

Deadlocks weren't the issue, insert serialization by the FKey locks was
the issue.

> several other bad schemes.... Alvaro, there are many pints waiting for you 
> from a great many postgresql users if you can eliminate this problem with the 
> work you're doing on shared row locks. 

Agreed.

-- 



pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: argtype_inherit() is dead code
Next
From: Bruce Momjian
Date:
Subject: Re: Problem with PITR recovery