Re: pg_dump and inherits issue - Mailing list pgsql-hackers

From Greg Stark
Subject Re: pg_dump and inherits issue
Date
Msg-id 87r70qk845.fsf@stark.xeocode.com
Whole thread Raw
In response to pg_dump and inherits issue  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-hackers
"Jim Buttafuoco" <jim@contactbda.com> 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 you're a child of another table that has them. But Postgres
doesn't yet track where constraints came from or check that you don't drop
ones that are inherited.

-- 
greg



pgsql-hackers by date:

Previous
From: Phil Frost
Date:
Subject: Re: lastval exposes information that currval does not
Next
From: Simon Riggs
Date:
Subject: Re: Online index builds