Re: [HACKERS] pg7.3b1 - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] pg7.3b1
Date
Msg-id 200210040229.g942TCa26961@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] pg7.3b1  (Rod Taylor <rbt@rbt.ca>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_dump and inherited attributes
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Anyone want to assist with the translation of