X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1128E475CA6 for ; Wed, 12 Feb 2003 02:49:14 -0500 (EST) Received: from yavin.anthesi.com (unknown [213.21.139.2]) by postgresql.org (Postfix) with ESMTP id 3407B475B8A for ; Wed, 12 Feb 2003 02:49:08 -0500 (EST) Received: by YAVIN with Internet Mail Service (5.5.2653.19) id <1458WD9K>; Wed, 12 Feb 2003 08:49:12 +0100 Message-ID: From: Alessandro Pedrotti To: pgsql-sql@postgresql.org Subject: R: adding not null constraints on columns Date: Wed, 12 Feb 2003 08:49:11 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2D26B.3B085290" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/253 X-Sequence-Number: 11651 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2D26B.3B085290 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: quoted-printable ALTER TABLE myTable ADD CONSTRAINT constraintName CHECK (myColumn IS NOT NULL); =20 -----Messaggio originale----- Da: Susan [mailto:brknrose@counterconspiracy.org] Inviato: mercoled=EC 12 febbraio 2003 00:45 A: pgsql-sql@postgresql.org Oggetto: [SQL] adding not null constraints on columns Is there a way to add not null constraints on a column after the column has been created? Any help would be appreciated. Thanks. =20 The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.=20 Nathaniel Borenstein (1957 - ) =20 brknrose@counterconspiracy.org =20 =20 ------_=_NextPart_001_01C2D26B.3B085290 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable Message
ALTER TABLE myTable ADD CONSTRAINT constraintName CHECK (myColumn IS NOT NULL);
 
-----Messaggio originale-----
Da: Susan=20 [mailto:brknrose@counterconspiracy.org]
Inviato: mercoled=EC 12 f= ebbraio=20 2003 00:45
A: pgsql-sql@postgresql.org
Oggetto: [SQL] a= dding=20 not null constraints on columns

Is there a way to add not null constr= aints=20 on a column after the column has been created?  Any help would be=20 appreciated.  Thanks.
 
The most likely way for the world to be destroyed, most experts agree, = is by=20 accident. That's where we come in; we're computer professionals. We cause= =20 accidents.=20
Nathaniel Borenstein (1957 - )
 
brknrose@counterconspiracy.o= rg
 
------_=_NextPart_001_01C2D26B.3B085290--