
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?

Thanks,

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
-----------------------------------
NextBus say: 
Riders prefer to arrive just minute 
before bus than just minute after.


Thu, 26 Sep 2002 13:46:33 -0700 (PDT)
Laurette Cisneros <laurette@nextbus.com>
pg7.3b1
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?

-- 
  Rod Taylor


26 Sep 2002 16:52:57 -0400
Rod Taylor <rbt@rbt.ca>
Re: pg7.3b1
I'll see if I can pare down my scripts (they are long) to reproduce this
easier.

L.
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
-----------------------------------
NextBus say: 
Riders prefer to arrive just minute 
before bus than just minute after.


Thu, 26 Sep 2002 13:55:53 -0700 (PDT)
Laurette Cisneros <laurette@nextbus.com>
Re: pg7.3b1
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?


Wed, 2 Oct 2002 16:03:34 -0700 (PDT)
Laurette Cisneros <laurette@nextbus.com>
Re: 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" 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
02 Oct 2002 20:16:12 -0400
Rod Taylor <rbt@rbt.ca>
Re: [HACKERS] pg7.3b1

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

Thu, 3 Oct 2002 22:29:12 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] pg7.3b1

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

Wed, 9 Oct 2002 12:27:01 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] pg7.3b1