Re: AW: [HACKERS] Another TEMP table trick

Bruce Momjian wrote:
>
> > There could be a problem with GUI tools that rely on these rows
> > to format their output (like pgaccess or ODBC --> M$ Access) though.
>
> Oh, never thought of that. A select of pg_class will return no rows for
> that table because it is a temp table.

One more reson to move \d from psql to backend maybe with syntax like
Oracle's "DESC xxx" unless there is something in ANSI standard for that.

Or implement the ANSI system tables (I think there were some ;) and
views.

Then the front-end tools can be advised to use these (and TEMP TABLES
can
add rows to other (possibly structure-permanent) TEMP tables that are
UNIONed
withe real pg_class to give them real values.

Or we can even implement just temp _rows_ for tables that exist in a
session only (maybe like in independant uncommitted transactions),
and add the info for temp tables to pg_class (and friends) as temp rows.

----------------
Hannu