> > Our code even masks a real table created in the same session. Once
> > the temp table is dropped, the real table becomes visible again. See
> > the regression tests for an example of this.
>
> The real problem here is that there's no way of finding out whether you
> just dropped the temporary table or the "real" one or whether a table is
> temporary at all. Sure you can perhaps look into pg_class but tell that to
> users.
Do a \d on the table. If it doesn't show up, it is temporary. ;-)
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026