Skip site navigation (1) Skip section navigation (2)

Re: removing a restriction

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Allison <tom(at)tacocat(dot)net>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: removing a restriction
Date: 2007-05-31 01:34:18
Message-ID: 465E261A.3050209@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
Tom Allison wrote:
> alter TABLE user_history ALTER COLUMN seen_as set not null;
> 
> turns it on...
> I want to turn it off....

DROP NOT NULL;

> 
> On May 30, 2007, at 9:05 PM, Joshua D. Drake wrote:
> 
>>
>> Tom Allison wrote:
>>> I have a column that was created with a 'not null' restriction.
>>> How do I remove it?
>>
>> alter table set
>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 4: Have you searched our list archives?
>>>               http://archives.postgresql.org/
>>
>>
>> -- 
>>       === The PostgreSQL Company: Command Prompt, Inc. ===
>> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
>> Providing the most comprehensive  PostgreSQL solutions since 1997
>>              http://www.commandprompt.com/
>>
>> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>> PostgreSQL Replication: http://www.commandprompt.com/products/
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


In response to

pgsql-general by date

Next:From: Gabriel LaetDate: 2007-05-31 02:01:14
Subject: Re: Design Table & Search Question
Previous:From: Tom AllisonDate: 2007-05-31 01:28:56
Subject: Re: removing a restriction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group