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

relation ### modified while in use

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: relation ### modified while in use
Date: 2000-10-23 01:32:55
Message-ID: Pine.BSO.4.10.10010222130100.22422-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I'm having the error 'relation <number> modified while in use' fairly
often. It is the same relation that's always giving a problem. Usually
after all currently-running backends die away with that error, error
disappears. If I shutdown, ipcclean, start up postgres, it also
disappears.


What causes this? I'm having a feeling that it has to do with referential
integrity (the table in question is referenced by almost every other
table), and with [possibly] a leak of reference counts? 

This is all with pg7.0.2 on i386.

-alex


Responses

pgsql-hackers by date

Next:From: Kevin O'GormanDate: 2000-10-23 02:43:22
Subject: Holes in the install process
Previous:From: Vince VielhaberDate: 2000-10-23 01:13:18
Subject: Re: AnonCVS access?

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