[HACKERS] pg_dump and inherits issue

2006-07-12 Thread Jim Buttafuoco
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

Re: [HACKERS] pg_dump and inherits issue

2006-07-12 Thread Greg Stark
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 as