Re: Delete with subquery deleting all records

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Delete with subquery deleting all records
Дата
Msg-id 4656F671.60004@g2switchworks.com
обсуждение исходный текст
Ответ на Re: Delete with subquery deleting all records  (Francisco Reyes <lists@stringsutils.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cache lookup failed for type 0
Следующее
От: Erik Jones
Дата:
Сообщение: Re: why postgresql over other RDBMS