Good catch. Thank you very much! On Fri, Oct 23, 2015 at 10:50 AM, Predrag Maric <predr...@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.
