Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group