Postgres Pro
Downloads
Home   >   mailing lists

Re: clone_schema function - Mailing list pgsql-general

From Melvin Davidson
Subject Re: clone_schema function
Date
Msg-id CANu8FiwiBiAjYgdehYBkJcSRFd6ZFFnN5kDJE7TG4rad5BNXZQ@mail.gmail.com
Whole thread Raw
In response to Re: clone_schema function  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: clone_schema function
List pgsql-general
Tree view
Yes, however, the documentation would be a lot clearer if it said "copies all constraints except foreign keys". I've made this known.

At any rate, I've attached a new version of the function that now does copy the foreign keys. Let me know if I missed anything else.

On Thu, Sep 10, 2015 at 9:09 AM, Igor Neyman <ineyman@perceptron.com> wrote:

 

 

From: Melvin Davidson [mailto:melvin6925@gmail.com]
Sent: Wednesday, September 09, 2015 4:48 PM
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] clone_schema function

 

Thanks Igor,

hmm, apparently the "INCLUDING CONSTRAINTS' option of "CREATE TABLE' has a glitch and only includes the primary key.

I also noticed that INCLUDING ALL generates an error, so I'll have to report that also.

I'll go eat some crow and work on a fix to add all constraints in the meantime.

 

 

It’s not a bug.

According to docs:

“Not-null constraints are always copied to the new table. CHECK constraints will only be copied if INCLUDING CONSTRAINTS is specified; other types of constraints will never be copied.”

So, FK constraints are not supposed to be copied.

 

Regards,

Igor Neyman




--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Attachment

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: clone_schema function
Next
From: Ioana Danes
Date:
Subject: Error when installing the bdr extension