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

Reply via email to