"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> The check constraints on table s are not like the original, I have an extra
> t_a_check constraint. Is this correct?
I wouldn't say it's correct but it is known.
I think the plan is to have such constraints be marked so you *can't* drop
them as long
I have an issue with pg_dump and inherits with pg 8.1.3 and 8.1.4
if I run the following SQL
create table t (a text check (a = '*'));
create table s () inherits (t);
alter table s drop constraint t_a_check;
alter table s add constraint a_check check (a='s');
I get the following
Table "public