Re: cannot CREATE INDEX because it has pending trigger events

2019-08-28 Thread Simon Kissane
On Tue, Aug 27, 2019 at 5:59 PM Laurenz Albe wrote: > > On Tue, 2019-08-27 at 12:00 +1000, Simon Kissane wrote: > > We have an application that works fine with Postgres 9.6, but fails > > with this error when we try installing it against 11.5 > > > > I simplified the

cannot CREATE INDEX because it has pending trigger events

2019-08-27 Thread Simon Kissane
having a deferred FK to check should stop me from creating a unique index. I also don't understand why this worked in 9.6 but not anymore. Thank you Simon Kissane