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
- Re: [HACKERS] relation ### modified while in use Alex Pilosov
- Re: [HACKERS] relation ### modified while in use Tom Lane
- Re: [HACKERS] relation ### modified while in use Alex Pilosov
- Re: [HACKERS] relation ### modified while in us... Tom Lane
- Re: [HACKERS] relation ### modified while i... Alex Pilosov
- Re: [HACKERS] relation ### modified wh... Tom Lane
- Re: [HACKERS] relation ### modified wh... Alex Pilosov
- Re: [HACKERS] relation ### modified while i... Alex Pilosov
- Re: [HACKERS] relation ### modified while i... Philip Warner