ON COMMIT action not catalogued?

Started by Peter Eisentrautover 14 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

(Going through some loose ends in the information schema ...)

Is my understanding right that the ON COMMIT action of temporary tables
is not recorded in the system catalogs anywhere? Would make sense,
wouldn't be a big problem, just want to make sure I didn't miss
anything.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: ON COMMIT action not catalogued?

Peter Eisentraut <peter_e@gmx.net> writes:

(Going through some loose ends in the information schema ...)
Is my understanding right that the ON COMMIT action of temporary tables
is not recorded in the system catalogs anywhere? Would make sense,
wouldn't be a big problem, just want to make sure I didn't miss
anything.

Yes, it's just remembered in local state within the owning backend.

regards, tom lane