Re: Testing DDL deparsing support

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Ian Barwick <ian(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Testing DDL deparsing support
Date: 2014-12-09 20:04:13
Message-ID: 20141209200413.GB24487@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Dec 8, 2014 at 12:43:36PM -0500, Robert Haas wrote:
> On Sat, Dec 6, 2014 at 10:43 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > This causes creation DDL is checked if it is used in the regression
> > database, but what about ALTER and DROP? pg_dump doesn't issue those,
> > except in special cases like inheritance.
>
> The proposed testing mechanism should cover any ALTER commands that
> are in the regression tests provided that those objects are not
> subsequently dropped -- because if the ALTER commands aren't replayed
> properly, then the later pg_dump won't produce the same output.
>
> There probably are some gaps in our current regression tests in this
> area, but that's probably a good thing to fix regardless of this.

OK, I understand now that the ALTERs are being passed to the slave and
we then can test that against pg_dump --- sounds good.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2014-12-09 20:15:54 Re: WIP: multivariate statistics / proof of concept
Previous Message Robert Haas 2014-12-09 19:11:49 Re: moving from contrib to bin