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

From Tom Lane
Subject Re: FKs on temp tables: hard, or just omitted?
Date
Msg-id 7702.1130560067@sss.pgh.pa.us
Whole thread Raw
In response to FKs on temp tables: hard, or just omitted?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Are foreign keys on temp tables not allowed just because nobody requested 
> them, or because they're hard to do?

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: 8.1 Release Candidate 1 Coming ...
Next
From: Dave Page
Date:
Subject: Re: 8.1 Release Candidate 1 Coming ...