-----Original Message-----
From: pgsql-hackers-owner@postgresql.org on behalf of Sander Steffann
Sent: Sat 10/29/2005 1:54 PM
To: josh@agliodbs.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