Add option to use schema names in the actual queries instead of search_path changes

[ThiefMaster]

e.g. DROP TABLE foo.bar instead of setting the search path to foo and then DROP TABLE bar.

[ArtursL]

Since postgres 9.6.8 and 10.3 , pg_dump outputs fully qualified names instead of setting search_path. So a feature like this is needed in order to be compatible with the latest postgres versions.

[ellmkay]

The schema qualified part is already implemented here: https://github.com/ellmkay/apgdiff

[jonnio]

I also solved the issue with a much newer fork: https://github.com/jonnio/apgdiff

[jflambert]

@jonnio Does your fork solve the PostgreSQL 10 sequence issue #225 ?

[elidorio]

Hello! Where did I download the latest * .jar with implementations that are running PostgreSQL 10? I tried to use the release version apgdiff 2.5.0-alpha.2, but is generating errors, as issue # 239 opened 10 days ago by me. Thank you.

[jonnio]

Yes, I believe so. The test case works!

Jon Osborn

Bell Tracy, Ltd.

http://www.belltracy.com

From: jflambert [email protected] Reply-To: fordfrog/apgdiff [email protected] Date: Tuesday, July 10, 2018 at 9:16 AM To: fordfrog/apgdiff [email protected] Cc: Jon Osborn [email protected], Mention [email protected] Subject: Re: [fordfrog/apgdiff] Add option to use schema names in the actual queries instead of search_path changes (#173)

@jonnio Does your fork solve the PostgreSQL 10 sequence issue #225 ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[jonnio]

I built from my fork and ran against latest postgres instances that previously failed. Works great.

[elidorio]

Excuse me, Can you pass me the path of the compiled jar of your fork?