Re: creating CHECK constraints as NOT VALID

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>

To: Thom Brown <thom@linux.com>

Cc: Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2011-06-02T00:56:12Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix pg_get_constraintdef to cope with NOT VALID constraints
- 048417511aef 9.1.0 cited

Excerpts from Thom Brown's message of mié jun 01 19:48:44 -0400 2011:

> Is this expected?
> [ pg_dump fails to preserve not-valid status of constraints ]

Certainly not.

> Shouldn't the constraint be dumped as not valid too??

Sure, I'll implement that tomorrow.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support