| Lists: | pgsql-hackers |
|---|
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | ON COMMIT action not catalogued? |
| Date: | 2011-07-15 04:46:41 |
| Message-ID: | 1310705201.13354.2.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
(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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ON COMMIT action not catalogued? |
| Date: | 2011-07-15 14:33:17 |
| Message-ID: | 29478.1310740397@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)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