Re: [HACKERS] relation 71478240 deleted while still in use on 8.1

2007-03-21 Thread Grzegorz Jaskiewicz
okay, I got it. The main reason behind it - is that I do drop table in transaction. Every 10 minutes. So during that period, when 'replication' is running - the thing becomes unstable, and this error can appear. -- Grzegorz Jaskiewicz C/C++ freelance for hire ---

Re: [HACKERS] relation 71478240 deleted while still in use on 8.1

2007-03-21 Thread Grzegorz Jaskiewicz
On Mar 21, 2007, at 11:25 PM, Tom Lane wrote: Grzegorz Jaskiewicz <[EMAIL PROTECTED]> writes: should I add it as a bug ? Only if you can reproduce it in 8.2 okie dokie, I am moving the DB onto 8.2 next week (120M of rows, and 8.2 does sorting much faster). -- Grzegorz Jaskiewicz C/C++

Re: [HACKERS] relation 71478240 deleted while still in use on 8.1

2007-03-21 Thread Tom Lane
Grzegorz Jaskiewicz <[EMAIL PROTECTED]> writes: > should I add it as a bug ? Only if you can reproduce it in 8.2 --- what it looks like to me is a relcache-opening race condition, which is (believed) fixed in 8.2 and is not feasible to fix in older branches. regards, tom l

Re: [HACKERS] relation 71478240 deleted while still in use on 8.1

2007-03-21 Thread Heikki Linnakangas
Grzegorz Jaskiewicz wrote: I got : 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in use 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in use 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in use on 8.1.8 my production se