Re: ALTER TABLE lock downgrades have broken pg_upgrade - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: ALTER TABLE lock downgrades have broken pg_upgrade
Date
Msg-id 20160503172541.GA31942@alvherre.pgsql
Whole thread Raw
In response to Re: ALTER TABLE lock downgrades have broken pg_upgrade  (Stephen Frost <sfrost@snowman.net>)
Responses Re: ALTER TABLE lock downgrades have broken pg_upgrade  (Stephen Frost <sfrost@snowman.net>)
Re: ALTER TABLE lock downgrades have broken pg_upgrade  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Stephen Frost wrote:
> * Alvaro Herrera (alvherre@2ndquadrant.com) wrote:
> > Tom Lane wrote:
> > 
> > > More generally, though, I wonder how we can have some test coverage
> > > on such cases going forward.  Is the patch below too ugly to commit
> > > permanently, and if so, what other idea can you suggest?
> > 
> > I suggest a buildfarm animal running a custom buildfarm module that
> > exercises the pg_upgrade test from every supported version to the latest
> > stable and to master -- together with your proposed case that leaves a
> > toastless table around for pg_upgrade to handle.
> 
> That would help greatly with pg_dump test coverage as well..  One of the
> problems of trying to get good LOC coverage of pg_dump is that a *lot*
> of the code is version-specific...

If we can put together a script that runs test.sh for various versions
and then verifies the runs, we could use it in both buildfarm and
coverage.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ALTER TABLE lock downgrades have broken pg_upgrade
Next
From: Andrew Dunstan
Date:
Subject: Re: ALTER TABLE lock downgrades have broken pg_upgrade