Excerpts from Andrew Dunstan's message of lun jul 25 22:44:32 -0400 2011:
> On 07/25/2011 10:31 PM, Jerry Sievers wrote:
> > Hackers;
> > I just noticed that somewhere between 8.2 and 8.4, an exception is
> > raised trying to alter table ONLY some_partition_parent ADD CHECK
> > (foo).
> 8.4 had this change:
> Force child tables to inherit CHECK constraints from parents
> (Alex Hunsaker, Nikhil Sontakke, Tom)
> You're not the only one who occasionally bangs his head against it.
Yeah. I think it's good that there's a barrier to blindly dropping a
constraint that may be important to have on children, but there should
be a way to override that.
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: _石头||Date: 2011-07-26 07:21:05|
|Subject: How to use CreateFunctionStmt's RETURN TABLE?|
|Previous:||From: Tom Lane||Date: 2011-07-26 03:25:18|
|Subject: Re: Error calling PG_RETURN_NULL() |