Re: Temporary Views

"Sander Steffann" <sander@steffann.nl> writes:
> Now I am thinking about it, referential integrity also behaves funny with
> temp tables. The following is allowed:

>> create temp table a (x int primary key);
>> create table b (y int references a(x));

It is?

regression=# create temp table a (x int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'a_pkey' for table 'a'
CREATE TABLE
regression=# create table b (y int references a(x));
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  ALTER TABLE / ADD CONSTRAINT: Unable to reference temporary table from permanent table constraint

Now I realize that this existing special-case argues against the
position I'm taking.  But let's argue from actual facts, not
misstatements...
        regards, tom lane