restrict null in column??

From: "James Newman" <jamesn(at)cisonic(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: restrict null in column??
Date: 2002-05-08 19:55:01
Message-ID: 000801c1f6ca$40ad2400$18dcb8d1@JAMESN
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I'm trying to design a database and am trying to restrict the use of null values in the columns. When I create the column and check the box to restrict the null values, I can't save it. It gives me this error:

-2147467259: error while executing the query;
ERROR: adding not null columns is not implemented. Add the column, then use Alter Table Add Constraint.

In pgAdmin, you can view the column properties after you saved it, but can't change the null value state. Am I doing something wrong? do I have an old version or is this just another Postgres issue that I have to work around?

Thanks
James Newman
Castleberry Investments

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-05-09 07:47:23 Re: Database Migration Plugin and auto increments
Previous Message Synchronizer 2002-05-08 19:11:39 Urgent - Help - Required - Postgres - 6.5