Truncate if exists
Sébastien Lardière <slardiere@hi-media.com>
From: Sébastien Lardière <slardiere@hi-media.com>
To: pgsql-hackers@postgresql.org
Cc: cedric@2ndquadrant.fr
Date: 2012-10-09T08:33:23Z
Lists: pgsql-hackers
Attachments
- truncateifexists.diff (text/x-patch) patch
Hi, With the help of Cédric, here's a patch changing the TRUNCATE TABLE command, adding the IF EXISTS option to allow the presence in the list of tables of a missing or invisible table. This meets the needs of scripts that should be run in different stages, and do not always have the same visibility on the tables, as well as DROP TABLE. Rather than rollback the entire TRUNCATE or transaction, we prefer to ignore the absence of the table. It is a small patch which changes very little code, but that could be quite useful. Regards, -- Sébastien Lardière PostgreSQL DBA Team Manager Hi-Media