Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg7.3b1

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Laurette Cisneros <laurette(at)nextbus(dot)com>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] pg7.3b1
Date: 2002-10-09 16:27:01
Message-ID: 200210091627.g99GR1v16748@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Sandeep ChadhaDate: 2002-10-09 16:46:18
Subject: Re: [GENERAL] Point in Time Recovery WAS: Hot Backup
Previous:From: Bruce MomjianDate: 2002-10-09 16:21:50
Subject: Re: AIX compilation problems (was Re: [HACKERS] Proposal ...)

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-10-09 16:27:44
Subject: Re: Doc Updates
Previous:From: Bruce MomjianDate: 2002-10-09 16:23:34
Subject: Re: another attempt at fixing contrib/rserv...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group