Jeff Davis <pg...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers