Replace tests of ALTER DATABASE RESET TABLESPACE.

Noah Misch <noah@leadboat.com>

Commit: 4adb0380b9bff5ec6424a9e87f76f8974b025367
Author: Noah Misch <noah@leadboat.com>
Date: 2025-09-12T19:44:14Z
Replace tests of ALTER DATABASE RESET TABLESPACE.

This unblocks rejection of that syntax.  One copy was a misspelling of
"SET TABLESPACE pg_default" that instead made no persistent changes.
The other copy just needed to populate a DATABASEOID syscache entry.
This slightly raises database.sql test coverage of catcache.c, while
dbcommands.c coverage remains the same.

Reported-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/1802710.1757608564@sss.pgh.pa.us

Files

Discussion