changes to table creation syntax in 7.1.2? - Mailing list pgsql-sql

From Jayson Callaway
Subject changes to table creation syntax in 7.1.2?
Date
Msg-id 9lvc15$1tr7$1@news.tht.net
Whole thread Raw
Responses Re: changes to table creation syntax in 7.1.2?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: changes to table creation syntax in 7.1.2?  (Jason Earl <jdearl@yahoo.com>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: getting the oid for a new tuple in a BEFORE trigger
Next
From: Stephan Szabo
Date:
Subject: Re: changes to table creation syntax in 7.1.2?