pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brendan McKenna <brendan@w3s.ie>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] parser: parse error at or near... with create table
Date: Fri, 30 Jul 1999 18:13:47 +0000
Message-ID: <199907301708.SAA10602@w3s.ie> (raw)
In-Reply-To: <m11AFjI-0000cIC@druid.net>

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





view thread (6+ messages)  latest in thread

Message-ID: <199907301708.SAA10602@w3s.ie>
Permalink:  ../199907301708.SAA10602@w3s.ie/
Also on:    postgresql.org/message-id/199907301708.SAA10602@w3s.ie

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: brendan@w3s.ie
  Subject: Re: [INTERFACES] parser: parse error at or near... with create table
  In-Reply-To: <199907301708.SAA10602@w3s.ie>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox