Received: from web10008.mail.yahoo.com (web10008.mail.yahoo.com [216.136.130.44]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7TKYof03654 for ; Wed, 29 Aug 2001 16:34:50 -0400 (EDT) (envelope-from jdearl@yahoo.com) Message-ID: <20010829203447.73191.qmail@web10008.mail.yahoo.com> Received: from [12.18.144.101] by web10008.mail.yahoo.com via HTTP; Wed, 29 Aug 2001 13:34:47 PDT Date: Wed, 29 Aug 2001 13:34:47 -0700 (PDT) From: Jason Earl Subject: Re: changes to table creation syntax in 7.1.2? To: Jayson Callaway , pgsql-sql@postgresql.org In-Reply-To: <9lvc15$1tr7$1@news.tht.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200108/354 X-Sequence-Number: 4604 It looks like it works here :(. Do you have an error message? processdata=# select version(); version --------------------------------------------------------------- PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.95.4 (1 row) processdata=# CREATE TABLE category processdata-# ( processdata(# uid int4 PRIMARY KEY, processdata(# description text NOT NULL, processdata(# parent int4 NULL REFERENCES category(uid) processdata(# ) processdata-# processdata-# ; NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'category_pkey' for table 'category' NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE --- Jayson Callaway wrote: > In postgres 7.0.x I had some working code that > lookes something like: > > CREATE TABLE category > ( > uid int4 PRIMARY KEY, > description text NOT NULL, > parent int4 NULL REFERENCES category(uid) > ) > > After upgrading to postgres 7.1.2 however this > syntax is not accepted > anymore. I receive an error that says it can not > create the reference > because the table category does not exist. > > How do I setup this type of reference structure in > 7.1.2? Did the syntax > change? > > I am running under Linux. > -- > Jayson Callaway > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com