Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Rod Taylor wrote:
> Same rule patch, right email this time :)
>
> Lock on the rule relation wasn't removed after adding the comment.
>
> On Wed, 2002-10-02 at 19:03, Laurette Cisneros wrote:
> > Ok, finally had time to narrow this down.
> >
> > Here's the simplified script that will reproduce this (this sequence
> > reroduces on my system using 7.3b2):
> >
> > \echo BEGIN tst.sql
> >
> > create table pp
> > ( x integer
> > , i text
> > );
> >
> > create view p as
> > select * from pp where i is null;
> >
> > comment on view p is
> > 'This is a comment.';
> >
> > create rule p_ins as on insert to p do instead
> > insert into pp
> > values ( new.x
> > , null
> > );
> >
> > comment on rule p_ins is 'insert to p goes to pp';
> >
> > \echo END tst.sql
> >
> >
> > On 26 Sep 2002, Rod Taylor wrote:
> >
> > > On Thu, 2002-09-26 at 16:46, Laurette Cisneros wrote:
> > > >
> > > > I am so glad that postgres now keeps track of relationships between rule,
> > > > views, functions, tables, etc. I've had to re-do all my creation and drop
> > > > scripts but this is definitely for the better.
> > > >
> > > > During my testing of my scripts, I have come across this message:
> > > > psql:/u1/cvs73/DataBase/Config/Schema/logconfig.sql:142: WARNING: Relcache reference leak: relation
"positions"has refcnt 1 instead of 0
> > > >
> > > > What does this indicate?
> > >
> > > Someone (probably me) made a mistake and forgot to release a cache
> > > handle.
> > >
> > > Do you happen to have a sequence of commands that can reproduce this?
> > >
> > >
> >
> > --
> > Laurette Cisneros
> > The Database Group
> > (510) 420-3137
> > NextBus Information Systems, Inc.
> > www.nextbus.com
> > ------------------------------
> > Do you know where your bus is?
> >
> >
> --
> Rod Taylor
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073