Re: pg_restore issues with intarray

2019-09-06 Thread Adrian Klaver
On 9/6/19 8:45 AM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 5:05 PM, Kevin Brannen wrote: It feels like the restore is adding the intarray extension, which does a CREATE OPERATOR FAMILY on its own, then later the restore does CREATE OPERATOR FAMILY on again causing the problem. Yet t

RE: pg_restore issues with intarray

2019-09-06 Thread Kevin Brannen
>From: Jerry Sievers > > >Try running \dx+ for intarray on one of your deviant systems. You may find >the item pg_dump is trying to be explicit about *missing* from the extension >member list. > >In such a case, see the ALTER EXTENSION ADD... which can be run manually to >register whatever is

Re: pg_restore issues with intarray

2019-09-06 Thread Jerry Sievers
Kevin Brannen writes: >>From: Jerry Sievers >> >>>Kevin Brannen writes: >>> >>> It feels like the restore is adding the intarray extension, which does >>> a CREATE OPERATOR FAMILY on its own, then later the restore does >>> CREATE OPERATOR FAMILY on again causing the problem. Yet this doesn't >

RE: pg_restore issues with intarray

2019-09-06 Thread Kevin Brannen
>From: Adrian Klaver >On 9/5/19 5:05 PM, Kevin Brannen wrote: >> >> It feels like the restore is adding the intarray extension, which does >> a CREATE OPERATOR FAMILY on its own, then later the restore does >> CREATE OPERATOR FAMILY on again causing the problem. Yet this doesn't >> happen on most

RE: pg_restore issues with intarray

2019-09-06 Thread Kevin Brannen
>From: Jerry Sievers > >>Kevin Brannen writes: >> >> It feels like the restore is adding the intarray extension, which does >> a CREATE OPERATOR FAMILY on its own, then later the restore does >> CREATE OPERATOR FAMILY on again causing the problem. Yet this doesn't >> happen on most of our databas

Re: pg_restore issues with intarray

2019-09-05 Thread Jerry Sievers
Kevin Brannen writes: >> On 9/5/19 4:24 PM, Adrian Klaver wrote: >> > On 9/5/19 4:06 PM, Kevin Brannen wrote: >> >>> From: Adrian Klaver >> >>> >> >>> On 9/5/19 2:57 PM, Kevin Brannen wrote: >> I think I need some help to understand what’s going here because I >> can’t figure it out an

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 5:05 PM, Kevin Brannen wrote: On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping.

RE: pg_restore issues with intarray

2019-09-05 Thread Kevin Brannen
> On 9/5/19 4:24 PM, Adrian Klaver wrote: > > On 9/5/19 4:06 PM, Kevin Brannen wrote: > >>> From: Adrian Klaver > >>> > >>> On 9/5/19 2:57 PM, Kevin Brannen wrote: > I think I need some help to understand what’s going here because I > can’t figure it out and google isn’t helping. >

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 4:24 PM, Adrian Klaver wrote: On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are upgr

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 4:06 PM, Kevin Brannen wrote: From: Adrian Klaver On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping. This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the

RE: pg_restore issues with intarray

2019-09-05 Thread Kevin Brannen
> From: Adrian Klaver > > On 9/5/19 2:57 PM, Kevin Brannen wrote: > > I think I need some help to understand what’s going here because I > > can’t figure it out and google isn’t helping. > > > > This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, > > or so the plan is.) Pg code c

Re: pg_restore issues with intarray

2019-09-05 Thread Adrian Klaver
On 9/5/19 2:57 PM, Kevin Brannen wrote: I think I need some help to understand what’s going here because I can’t figure it out and google isn’t helping… This is for Pg 9.6.5. (Yes, we are upgrading to 12.x in a few months, or so the plan is.) Pg code came from the community and we compiled it