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?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
