Re: [HACKERS] COPY with no WAL, in certain circumstances - Mailing list pgsql-patches

"Simon Riggs" <simon@2ndquadrant.com> writes:
> There is no failure condition where the rows continue to exist
> on disk && the table relfilenode shows a committed transaction pointing
> to the file containing the marked-valid-but-actually-not rows.

What of

BEGIN;
    CREATE TABLE foo ...;
    SAVEPOINT x;
        COPY foo FROM ...;
    ROLLBACK TO x;
COMMIT;

            regards, tom lane