Re: pg_upgrade test for binary compatibility of core data types

From: Jacob Champion <pchampion(at)vmware(dot)com>
To: "pryzby(at)telsasoft(dot)com" <pryzby(at)telsasoft(dot)com>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "peter(dot)eisentraut(at)enterprisedb(dot)com" <peter(dot)eisentraut(at)enterprisedb(dot)com>, "buschmann(at)nidsa(dot)net" <buschmann(at)nidsa(dot)net>, "andrew(at)dunslane(dot)net" <andrew(at)dunslane(dot)net>, "noah(at)leadboat(dot)com" <noah(at)leadboat(dot)com>, "bruce(at)momjian(dot)us" <bruce(at)momjian(dot)us>, "andres(at)anarazel(dot)de" <andres(at)anarazel(dot)de>, "tomas(dot)vondra(at)2ndquadrant(dot)com" <tomas(dot)vondra(at)2ndquadrant(dot)com>
Subject: Re: pg_upgrade test for binary compatibility of core data types
Date: 2021-07-16 16:40:34
Message-ID: e508464c63689fb67311a3ec929e9b77f01018aa.camel@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Fri, 2021-07-16 at 16:21 +0000, Jacob Champion wrote:
> On Fri, 2021-04-30 at 13:33 -0500, Justin Pryzby wrote:
> > On Sat, Mar 06, 2021 at 03:01:43PM -0500, Tom Lane wrote:
> > > v4-0001 mostly teaches test.sh about specific changes that have to be
> > > made to historic versions of the regression database to allow them
> > > to be reloaded into current servers. As already discussed, this is
> > > really duplicative of knowledge that's been embedded into the buildfarm
> > > client over time. It'd be better if we could refactor that so that
> > > the buildfarm shares a common database of these actions with test.sh.
> > > And said database ought to be in our git tree, so committers could
> > > fix problems without having to get Andrew involved every time.
> > > I think this could be represented as a psql script, at least in
> > > versions that have psql \if (but that came in in v10, so maybe
> > > we're there already).
> >
> > I started this. I don't know if it's compatible with the buildfarm client, but
> > I think any issues maybe can be avoided by using "IF EXISTS".
>
> I'm going to try pulling this into a psql script today and see how far
> I get.

I completely misread this exchange -- you already did this in 0004.
Sorry for the noise.

--Jacob

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-07-16 17:56:23 Re: BUG #17111: Database created, cannot be created, but reported as inexist
Previous Message Jacob Champion 2021-07-16 16:21:07 Re: pg_upgrade test for binary compatibility of core data types

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2021-07-16 16:40:38 Re: proposal: enhancing plpgsql debug API - returns text value of variable content
Previous Message Jacob Champion 2021-07-16 16:21:07 Re: pg_upgrade test for binary compatibility of core data types