Thread: pg7.3b1
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 refcnt1 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.
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 refcnt1 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
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" 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 ----------------------------------- NextBus say: Riders prefer to arrive just minute before bus than just minute after.
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?