Re: dropping partitions and concurrent reads

Jeff Davis <pgsql(at)j-davis(dot)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