Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3ANln896658 for ; Tue, 10 Apr 2001 19:47:49 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mail.pcl-hage.nl (mail.pcl-software.nl [193.172.210.25]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3A8rR872296 for ; Tue, 10 Apr 2001 04:53:27 -0400 (EDT) (envelope-from SvdMortel@InterPlein.nl) Received: (qmail 13751 invoked by uid 506); 10 Apr 2001 08:53:19 -0000 Received: from SvdMortel@InterPlein.nl by mail with qmail-scanner-0.94 (sweep: 2.1/3.42. . Clean. Processed in 1.17141 secs); 10/04/2001 10:53:18 Received: from unknown (HELO stanlp) (192.168.2.81) by 192.168.0.27 with SMTP; 10 Apr 2001 08:53:17 -0000 From: "Stan van de Mortel" To: Subject: Foreign Key between different databases Date: Tue, 10 Apr 2001 10:53:13 +0200 Message-ID: <000001c0c19b$af7b5100$5102a8c0@stanlp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/148 X-Sequence-Number: 2496 Hello, I've a table in a database and I want to create a column that is a foreign key to a table in an other database. When I try ...,foreign key (x) references otherdb.table(x) it says 'parse error at or near "."'. Is there an other way to create this kind of foreign key? Stan van de Mortel [SvdMortel@InterPlein.nl]