Re: replicating DROP commands across servers - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: replicating DROP commands across servers
Date
Msg-id CAMkU=1wXPmjS-5aCWVHbPhDW82KPQTtpp6nsFWnKxSmR3yZhOQ@mail.gmail.com
Whole thread Raw
In response to Re: replicating DROP commands across servers  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: replicating DROP commands across servers
List pgsql-hackers
On Mon, Dec 29, 2014 at 2:15 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Here's a patch that tweaks the grammar to use TypeName in COMMENT,
SECURITY LABEL, and DROP for the type and domain cases.  The required
changes in the code are pretty minimal, thankfully.  Note the slight
changes to the new object_address test also.

I think I'm pretty much done with this now, so I intend to push this
first thing tomorrow and then the rebased getObjectIdentityParts patch
sometime later.


This commit 3f88672a4e4d8e648d24ccc65 seems to have broken pg_upgrade for pg_trgm.

On 9.2.9 freshly initdb and started with default config:

$ createdb jjanes

in psql:

create extension pg_trgm ;
create table foo (x text);
create index on foo using gin (upper(x) gin_trgm_ops);

Then run 9.5's pg_upgrade and it fails at the stage of restoring the database schema.

The relevant log files are attached

Cheers,

Jeff


Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ]
Next
From: Heikki Linnakangas
Date:
Subject: Re: Redesigning checkpoint_segments