Received: from aeon.tvd.be (aeon.tvd.be [195.162.196.20]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBUGgrL96379 for ; Sat, 30 Dec 2000 11:42:57 -0500 (EST) (envelope-from tsmets@altern.org) Received: from altern.org (cable-213-132-132-244.upc.chello.be [213.132.132.244]) by aeon.tvd.be (8.9.3/8.9.3/RELAY-1.1) with ESMTP id RAA17655 for ; Sat, 30 Dec 2000 17:42:48 +0100 (MET) Message-ID: <3A4E0FC4.4D9EB1F8@altern.org> Disposition-Notification-To: Thomas SMETS Date: Sat, 30 Dec 2000 17:39:32 +0100 From: Thomas SMETS Organization: Private X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9-27mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: psql sql Subject: References to SERIAL Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200012/308 X-Sequence-Number: 648 Hi, If i create a "internal pk" buy defining on a table a field SERIAL. How do I reference this field in the other table to set the field possible value ? create table book ( /* This is an internal primary key for the book description */ book_pk serial, .... // End of Book def ); create table books_authors ( ??? // I want to reference the book pk & the author pk to be able to make the X-ref ? ); tx, THomas -- Sat Dec 30 15:23:42 CET 2000 Thomas SMETS e-mail : tsmets@altern.org Av. de la Brabançonne 133 / 3 Tel. : +32 (0)2 742. 05. 94. 1030 Bruxelles ======= Quote of the Day ========= "In the long run, every program becomes rococo, and then rubble." -- Alan Perlis ========= End of Quote ===========