Re: Disruptive corruption of data during an update - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Disruptive corruption of data during an update
Date
Msg-id 2213145.zEHI0nePpR@skynet.simkin.ca
Whole thread Raw
In response to Re: Disruptive corruption of data during an update  (Binand Sethumadhavan <binand@gmx.net>)
List pgsql-novice
On Thursday, March 29, 2012 05:03:03 PM Binand Sethumadhavan wrote:
> What I typically do is to attach "where 1 = 0" to inhibit a query from
> making any changes, if I find an error in a multiline query and do not
> want to Control-C out of psql.

It is also a good idea to always always do a "begin" before doing any manual
update, and only commit changes if it looks like it did the right thing.


pgsql-novice by date:

Previous
From: ennio
Date:
Subject: Re: Disruptive corruption of data during an update
Next
From: "Moon, James"
Date:
Subject: How to successfully create a new function?