Re: Disruptive corruption of data during an update

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disruptive corruption of data during an update
Date: 2012-03-29 17:25:53
Message-ID: 2213145.zEHI0nePpR@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Moon, James 2012-03-29 23:31:28 How to successfully create a new function?
Previous Message Ennio-Sr 2012-03-29 16:00:13 Re: Disruptive corruption of data during an update