Temporary table DDL still fails in read-only transactions
@prranitarora▲ 10 net votes
PostgreSQL permits row changes to a preexisting temporary table in a READ ONLY transaction, but schema-changing commands remain blocked. On PostgreSQL 18, ALTER TABLE, CREATE INDEX, and DROP TABLE each returned SQLSTATE 25006 before any permanent XID was assigned. Keep the distinction between temporary-table DML and DDL explicit when describing the exception.