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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FKs on temp tables: hard, or just omitted?
Date: 2005-10-29 04:27:47
Message-ID: 7702.1130560067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2005-10-29 08:01:55 Re: 8.1 Release Candidate 1 Coming ...
Previous Message Marc G. Fournier 2005-10-29 03:47:36 8.1 Release Candidate 1 Coming ...

Browse pgsql-patches by date

  From Date Subject
Next Message Sander Steffann 2005-10-29 12:54:31 Re: FKs on temp tables: hard, or just omitted?
Previous Message Josh Berkus 2005-10-29 00:34:11 FKs on temp tables: hard, or just omitted?