Re: "NOT NULL" - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: "NOT NULL"
Date
Msg-id 20050524172020.GB8129@wolff.to
Whole thread Raw
In response to Re: "NOT NULL"  (tövis <tovises@freemail.hu>)
List pgsql-novice
On Tue, May 24, 2005 at 14:40:00 +0200,
  tövis <tovises@freemail.hu> wrote:
> covering and completelly hide the ODBC/SQL surface. It is also object
> oriented and I cannot give string value for an integer (especially if its
> length only 4 byte instead of 7 characzter such as 'DEFAULT'). This is why

You aren't supposed to be using "'DEFAULT'", but rather "DEFAULT". It is
a keyword, not a value. It still may be that your software won't let
you use it. Using an explicit column list and leaving off the serial
field is probably your best bet.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sparse Data
Next
From: "Keith Worthington"
Date:
Subject: UPDATE with JOIN