Re: [HACKERS] 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? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 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. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] 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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] 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 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. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html