Re: Check constraints on partition parents only?
От | Alvaro Herrera |
---|---|
Тема | Re: Check constraints on partition parents only? |
Дата | |
Msg-id | 1311967863-sup-4173@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: Check constraints on partition parents only? (Nikhil Sontakke <nikkhils@gmail.com>) |
Ответы |
Re: Check constraints on partition parents only?
|
Список | pgsql-hackers |
Excerpts from Nikhil Sontakke's message of vie jul 29 14:12:37 -0400 2011: > Hi all, > > PFA, patch which implements non-inheritable "ONLY" constraints. This > has been achieved by introducing a new column "conisonly" in > pg_constraint catalog. Specification of 'ONLY' in the ALTER TABLE ADD > CONSTRAINT CHECK command is used to set this new column to true. > Constraints which have this column set to true cannot be inherited by > present and future children ever. > > The psql and pg_dump binaries have been modified to account for such > persistent non-inheritable check constraints. This patch also has > documentation changes along with relevant changes to the test cases. > The regression runs pass fine with this patch applied. > > Comments and further feedback, if any, appreciated. Did you look at how this conflicts with my patch to add not null rows to pg_constraint? https://commitfest.postgresql.org/action/patch_view?id=601 -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-hackers по дате отправления: