Re: psql - -dry-run option - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: psql - -dry-run option
Date
Msg-id 20151217204759.GP2618@alvherre.pgsql
Whole thread Raw
In response to Re: psql - -dry-run option  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway wrote:
> On 12/17/2015 11:58 AM, Christopher Browne wrote:
> > On 17 December 2015 at 14:16, Pavel Stehule <pavel.stehule@gmail.com
> > <mailto:pavel.stehule@gmail.com>> wrote:
> >> or different idea - just enforce syntax check without execution.
> > 
> > That seems pretty cool...  I'd find "syntax check without execution" to
> > be pretty useful to test SQL (and especially DDL).
> 
> Like this?
> https://github.com/jconway/pgsynck

I thought the idea was to test the execution of the commands themselves,
not just the syntax.  Something like add a column here and see whether
this other complex UPDATE populates it correctly.

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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [patch] Proposal for \rotate in psql
Next
From: Pavel Stehule
Date:
Subject: broken autocomplete in head