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
+ Everyone has their own god. +
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: