Re: dropping partitions and concurrent reads

Jeff Davis <pgsql@j-davis.com> writes:
> S1, S2 are concurrent sessions:

> S1: create table test_par (v int);
> S1: create table test_ch1 (check (v > 0 and v <= 2)) inherits (test_par);
> S1: create table test_ch2 (check (v > 2 and v <= 4)) inherits (test_par);
> S1: begin;
> S1: drop table test_ch1 cascade;

> S2: select * from test_par where v = 3;

> S1: commit;

> in S2 I get:

>   ERROR:  could not open relation with OID 66962

Oh?  Are you using 8.4+?
        regards, tom lane