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 CANu8FiwoTpcmPE52z57w+rrwC5id2kOdc28=dAez2sY9C_70iQ@mail.gmail.com
Whole thread Raw
In response to clone_schema function  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
Good catch. Thank you very much!

On Fri, Oct 23, 2015 at 10:50 AM, Predrag Maric <predrag4@gmail.com> wrote:
The script is generating foreign keys which reference tables in the source schema.
I had to change 

219    SELECT 'ALTER TABLE ' || quote_ident(dest_schema) || '.' || quote_ident(rn.relname) 
220                          || ' ADD CONSTRAINT ' || quote_ident(ct.conname) || ' ' || pg_get_constraintdef(ct.oid) || ';'

to 

219    SELECT 'ALTER TABLE ' || quote_ident(dest_schema) || '.' || quote_ident(rn.relname) 
220                         || ' ADD CONSTRAINT ' || quote_ident(ct.conname) || ' ' || replace(pg_get_constraintdef(ct.oid), quote_ident(source_schema) || '.', quote_ident(dest_schema) || '.') || ';'

I'm attaching the updated script.



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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: strange connection problem.
Next
From: "Day, David"
Date:
Subject: Re: strange connection problem.