relation ### modified while in use - Mailing list pgsql-hackers

From Alex Pilosov
Subject relation ### modified while in use
Date
Msg-id Pine.BSO.4.10.10010222130100.22422-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: relation ### modified while in use  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: AnonCVS access?
Next
From: "Kevin O'Gorman"
Date:
Subject: Holes in the install process