schema diff tool problem with owner statements

From: postgresql(at)yawebhost(dot)com
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: schema diff tool problem with owner statements
Date: 2021-11-11 19:14:55
Message-ID: 0100017d106ca4b3-a824301a-3bfa-49fd-9305-d2df673c77e4-000000@email.amazonses.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm trying to compare 2 schemas (devschema is the source and testschema
is the target) and generate a script that can be run on the target that
will create the missing tables.  I ran the schema diff, and it generated
items like this:

CREATE TABLE IF NOT EXISTS tablename
(
fields, etc
)
TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.tablename
    OWNER to devschema;

When I run the script on testschema, I don't want it trying to alter the
owner of the table because that statement will fail anyway.

I found a setting in "preferences" called "ignore owner", and set it to
true (If set to True, then the Schema Diff tool ignores the owner while
comparing the objects.)

However, this setting has no effect.  The alter table statements still
get generated, and I am left to remove them manually.

If there is something I'm doing wrong please let me now.  I swear this
setting worked many months ago when I used this tool, but it seems to
not be working now.

Version 6.1 (downloaded and updated today)

Thank you,

Wes

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Akshay Joshi 2021-11-12 05:58:30 Re: schema diff tool problem with owner statements
Previous Message Aditya Toshniwal 2021-11-11 08:59:46 Re: need help in restoring from tar file