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

Alban Hertroys writes:

> Why not use EXISTS?
>
> DELETE FROM export_messages WHERE NOT EXISTS (
>     SELECT 1
>       FROM exports
>      WHERE exports.export_id = export_messages.export_id
> )

Didn't think of it. Thanks for the code.

> I suppose you run those queries in a transaction block, right?

Correct.
Also I do a backup before doing the deletions.