Re: FKs on temp tables: hard, or just omitted? - Mailing list pgsql-hackers

From Dave Page
Subject Re: FKs on temp tables: hard, or just omitted?
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E48507FD@ratbert.vale-housing.co.uk
Whole thread Raw
In response to FKs on temp tables: hard, or just omitted?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers


-----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


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: FKs on temp tables: hard, or just omitted?
Next
From: Tom Lane
Date:
Subject: Re: 8.1 Release Candidate 1 Coming ...