Re: [INTERFACES] parser: parse error at or near... with create table - Mailing list pgsql-interfaces

From Brendan McKenna
Subject Re: [INTERFACES] parser: parse error at or near... with create table
Date
Msg-id 199907301708.SAA10602@w3s.ie
Whole thread Raw
In response to Re: [INTERFACES] parser: parse error at or near... with create table  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-interfaces
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




pgsql-interfaces by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [INTERFACES] parser: parse error at or near... with create table
Next
From: "Collin F. Lynch"
Date:
Subject: Re: [INTERFACES] libpgtcl.so.2.0