Received: from mail.ruhr.de (ns.ruhr.de [141.39.224.34]) by hub.org (8.9.3/8.9.3) with SMTP id GAA74828 for ; Wed, 7 Jul 1999 06:57:36 -0400 (EDT) (envelope-from olli@casbah.ruhr.de) Received: (qmail 87238 invoked by alias); 7 Jul 1999 10:58:19 -0000 Received: by casbah (Smail-3.2 1996-Jul-4 #1 #1) id m110j4d-0009zaC; Sun, 4 Jul 1999 12:00:35 +0200 (MEST) From: Oliver Graf Organization: Die Rauxeler Spielwiese ;-) To: blackgr , pgsql-sql@postgresql.org Subject: Re: [SQL] problem creating table Date: Sun, 4 Jul 1999 11:58:51 +0200 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain References: MIME-Version: 1.0 Message-Id: <99070412003400.01622@casbah> Content-Transfer-Encoding: 8bit > [...] > CREATE TABLE entity ( > [...] > position int2 not null, CONSTRAINT entitiy_pk > PRIMARY KEY (entity_id_number)); > > [...] > > CREATE TABLE phone ( > [...] > area_code char(3) not null, CONSTRAINT phone_pk > PRIMARY KEY (phone_id_number)); -- Oliver Graf Oberhofstr. 11 D-44575 Castrop-Rauxel, Germany Phone: +49 2305 14230 http://www.ruhr.de/home/casbah/