On Mon, Jun 04, 2007 at 04:06:47PM +0200, Michal Taborsky - Internet Mall wrote:
> 
> Wouldn't it be possible to check the script for these commands 
> beforehand, then? I mean, it would be real nice, if slonik produced an 
> error message, instead of breaking things.

Which version of Postgres are you on?  It may not actually break
things under post 8.x, because there's subtransaction support in
there.  

It would indeed be nice to have a slonik script validator in place to
run through before doing things; so far, nobody has been inspired to
write one, possibly because there's a great whack of things that it
probably wouldn't be able to test without completely reproducing
your setup.  I can say that we _never_ run a DDL without first trying
out the script in a test environment, for exactly this reason.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
The plural of anecdote is not data.
		--Roger Brinner