Re: Delete with subquery deleting all records - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Delete with subquery deleting all records
Date
Msg-id 4656F671.60004@g2switchworks.com
Whole thread Raw
In response to Re: Delete with subquery deleting all records  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Francisco Reyes wrote:
> Alban Hertroys writes:
>
>> I suppose you run those queries in a transaction block, right?
>
> Correct.
> Also I do a backup before doing the deletions.

Note that if you're in a transaction, you don't technically need the
backup (doesn't hurt though) as if you get it wrong you can just roll it
back.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: cache lookup failed for type 0
Next
From: Erik Jones
Date:
Subject: Re: why postgresql over other RDBMS