I have applied a more limited patch that mentions this. I do not want to mention _why_ we do not implement it because it is partly performance and partly complexity, I think, and some combinations make no sense, like temporary primary and non-temp foreign.
--------------------------------------------------------------------------- Jim C. Nasby wrote: > On Sun, Oct 30, 2005 at 05:31:07PM -0800, Josh Berkus wrote: > > Folks, > > > > Thanks, all! Now, if only I could remember who asked me the question ... > > ISTM we should add a note about this to the docs... > > Here's a patch for create_table.sgml, though there's probably some other > places this could go... > -- > Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: doc/src/sgml/ref/create_table.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v retrieving revision 1.94 diff -c -c -r1.94 create_table.sgml *** doc/src/sgml/ref/create_table.sgml 13 Aug 2005 02:48:18 -0000 1.94 --- doc/src/sgml/ref/create_table.sgml 31 Oct 2005 18:11:27 -0000 *************** *** 421,427 **** primary key of the <replaceable class="parameter">reftable</replaceable> is used. The referenced columns must be the columns of a unique or primary ! key constraint in the referenced table. </para> <para> --- 421,429 ---- primary key of the <replaceable class="parameter">reftable</replaceable> is used. The referenced columns must be the columns of a unique or primary ! key constraint in the referenced table. Note that foreign key ! constraints may not be defined between temporary tables and ! permanent tables. </para> <para>
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match