On Fri, Aug 22, 2014 at 03:12:47PM -0400, Robert Haas wrote: > On Fri, Aug 22, 2014 at 2:33 PM, Bruce Momjian <br...@momjian.us> wrote: > >> Yes, you remember well. I will have to find a different way for > >> pg_upgrade to call a no-op ALTER TABLE, which is fine. > > > > Looking at the ALTER TABLE options, I am going to put this check in a > > !IsBinaryUpgrade block so pg_upgrade can still use its trick. > > -1, that's really ugly. > > Maybe the right solution is to add a form of ALTER TABLE that is > specifically defined to do only this check. This is an ongoing need, > so that might not be out of line.
Ah, seems ALTER TABLE ... DROP CONSTRAINT IF EXISTS also works --- I will use that. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers