Re: FKs on temp tables: hard, or just omitted?

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org on behalf of Sander Steffann
Sent: Sat 10/29/2005 1:54 PM
To: josh(at)agliodbs(dot)com; Tom Lane
Cc: PostgreSQL-development
Subject: Re: [HACKERS] FKs on temp tables: hard, or just omitted? 
 
>> You can have foreign keys between temp tables, just not between temp and
>> permanent tables.  The latter case is either fairly silly, or
>> technically hard, depending on which direction you have in mind.

> A temp table referencing a permanent table wouldn't be very silly IMHO...

Err, no, not silly, but difficult. But the other direction would be silly which is what I think Tom meant.

Regards, Dave