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