add_exact_object_address(&object, targetObjects);

}

/*

* Object deletion might involve toast table access (to clean up

* toasted catalog entries), so ensure we have a valid snapshot.

*/

PushActiveSnapshot(GetTransactionSnapshot());

/*

* Since this is an automatic drop, rather than one directly initiated

* by the user, we pass the PERFORM_DELETION_INTERNAL flag.

*/

performMultipleDeletions(targetObjects, DROP_CASCADE,

PERFORM_DELETION_INTERNAL | PERFORM_DELETION_QUIETLY);

PopActiveSnapshot();

#ifdef USE_ASSERT_CHECKING

/*

1

(1 row)

COMMIT;

SELECT * FROM temptest;

ERROR: relation "temptest" does not exist

LINE 1: SELECT * FROM temptest;

^

-- Test it with a CHECK condition that produces a toasted pg_constraint entry

BEGIN;

do $$

begin

execute format($cmd$

CREATE TEMP TABLE temptest (col text CHECK (col < %L)) ON COMMIT DROP

$cmd$,

(SELECT string_agg(g.i::text || ':' || random()::text, '|')

FROM generate_series(1, 100) g(i)));

end$$;

SELECT * FROM temptest;

col

-----

(0 rows)

COMMIT;

SELECT * FROM temptest;

ERROR: relation "temptest" does not exist

SELECT*FROM temptest;

BEGIN;

do $$

execute format($cmd$

CREATE TEMP TABLE temptest (coltextCHECK (col< %L))ONCOMMIT DROP

$cmd$,

(SELECT string_agg(g.i::text||':'|| random()::text,'|')

FROM generate_series(1,100) g(i)));

end$$;

SELECT*FROM temptest;

COMMIT;

SELECT*FROM temptest;

CREATETABLEtemptest(colint)ONCOMMITDELETE ROWS;