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