Message-Id: <199907301708.SAA10602@w3s.ie>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] parser: parse error at or near... with create table 
In-Reply-To: Your message of "Fri, 30 Jul 1999 12:41:55 -0400."
	<m11AFjI-0000cIC@druid.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Fri, 30 Jul 1999 18:13:47 +0000
From: "Brendan McKenna" <brendan@w3s.ie>

Hi,

	My quick $0.02 worth...
: 
: I guess the main question is, will we allow the serial type to be NULL.
: If not will we allow the NOT NULL phrase anyway to simplify the grammar.
: If yes to either then let's allow the phrase now.
: 

	I don't see how you can allow a serial value to be null, since that 
would defeat the purpose of a serial (presuming there were more than one 
NULL-valued serial in a table).  I just don't see how, logically, a serial 
could allow NULLs (even if it may be desirable in some cases).

	On the other hand, I would allow the NOT NULL phrase, even though 
it's redundant.


							Brendan
-- 
Brendan McKenna	
Technical Director			Phone: +353-(0)61-338177 x4143
W3 Services Ltd.			  Fax: +353-(0)61-338065
Innovation Centre			Email: brendan@w3s.ie
National Technological Park
Limerick
Ireland