Thread: Re: [HACKERS] pg7.3b1
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" hasrefcnt 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
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
Patch applied with Tom's fix for heap_close(NoLock). Thanks. --------------------------------------------------------------------------- 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