From brknrose@counterconspiracy.org Tue Feb  11 23:44:00 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 308064759BD
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 18:44:00 -0500 (EST)
Received: from fed1mtao05.cox.net (fed1mtao05.cox.net [68.6.19.126])
	by postgresql.org (Postfix) with ESMTP id 6124A475925
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 18:43:59 -0500 (EST)
Received: from cinderella ([68.101.160.22]) by fed1mtao05.cox.net
	(InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP
	id <20030211234357.OJFG27824.fed1mtao05.cox.net@cinderella>
	for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 18:43:57 -0500
From: "Susan" <brknrose@counterconspiracy.org>
To: <pgsql-sql@postgresql.org>
Subject: adding not null constraints on columns
Date: Tue, 11 Feb 2003 15:44:50 -0800
Message-ID: <000601c2d227$91426400$0400a8c0@sd.cox.net>
MIME-Version: 1.0
Content-Type: multipart/related;
	boundary="----=_NextPart_000_0007_01C2D1E4.831F2400"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/226
X-Sequence-Number: 11624

This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C2D1E4.831F2400
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0008_01C2D1E4.831F2400"

------=_NextPart_001_0008_01C2D1E4.831F2400
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Is there a way to add not null constraints on a column after the column
has been created?  Any help would be appreciated.  Thanks.
 
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. 

Nathaniel Borenstein (1957 - )
 
brknrose@counterconspiracy.org

 

------=_NextPart_001_0008_01C2D1E4.831F2400
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D250024123-11022003>Is there a way to add not null constr=
aints=20
on a column after the column has been created?&nbsp; Any help would be=20
appreciated.&nbsp; Thanks.</SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV align=3Dleft>
<DIV align=3Dleft>
<DT>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.</FONT>=20
<DD><B><FONT size=3D-1>Nathaniel Borenstein (1957 - )</FONT></B></DD></DIV>
<DIV><STRONG><FONT size=3D2></FONT></STRONG>&nbsp;</DIV>
<DIV><STRONG><FONT size=3D2><A=20
href=3D"mailto:brknrose@counterconspiracy.org">brknrose@counterconspiracy.o=
rg</A></FONT></STRONG></DIV>
<DIV><IMG height=3D40 src=3D"cid:250024123@11022003-33D8" width=3D25 border=
=3D0><IMG=20
height=3D40 src=3D"cid:250024123@11022003-33DF" width=3D24 border=3D0><IMG =
height=3D40=20
src=3D"cid:250024123@11022003-33E6" width=3D27 border=3D0></DIV></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_001_0008_01C2D1E4.831F2400--

------=_NextPart_000_0007_01C2D1E4.831F2400
Content-Type: image/gif;
	name="ribbontsmall.gif"
Content-Transfer-Encoding: base64
Content-ID: <250024123@11022003-33D8>

R0lGODlhGQAoAPf/AP///5SUlK2trbW1tb29vcbGxs7OztbW1t7e3ufn5+/v
7/f3987GxtbOzufe3r21ta2lpca9vZyUlKWcnIyEhHNra4R7e2tjY72trWNa
WqWUlJSEhIx7e4RzczkxMbWcnKWMjGtaWmNSUr2cnLWUlJRzc0o5OaV7ezkp
KYxjY6Vzc1I5OYRaWjEhIUoxMZxjY0IpKaVjY2M5OUopKZRSUjEYGHMxMZxC
QjkYGCkQEJQxMTEQEDkQECEICIwhIQgAABAAABgAACEAADkAAFoAAHMAAHsA
AIQAAJQAAJQYEIwQCHsIAIQIAIwIAJwIAKVCOZw5MXsYEGsQCFoIAK1rY7Vr
Y5xSSpRCOXMhGFIQCJQYCJwYCJQQAKUQAK17c6VrY3tKQoRCOaU5KZQxIYwh
EJQhELWEe4QpGK1jUkohGK2MhL17a3trY3tza3NrY+/v587OxsbGve/378bO
xs7Wztbe1u/398bOzs7W1ikxvcbGzrW1vaWlra2ttb29xpycpYSEjGtrc62t
vaWltZycrYyMnJSUpYSElL291pyctZSUrVpaa1JSY5SUtYyMrVpaczk5SoSE
rYyMvXNznFpae4SEtWtrlCkpOVJSc2NjjEJCY3NzrTExSmtrpUpKc2NjnHNz
tWtrrTExUlJSjEpKhFJSnEJChEpKlBgYMUpKnFJStUJClDk5jDk5lDk5nEJC
tTk5pRAQMRAQOSkplCEhhAgIISEhjBAQWhgYlAgIQhAQhBAQjBAQlAgIWhAQ
vQgIYwgIhAgIjAgIlAgIxgAACAAAEAAAGAAAIQAAKQAAMQAAOQAASgAAWgAA
YwAAawAAcwAAewAAhAAAjAAAlAAAnAAApQAAvQAAxhAIrQgApQgAtTEpnAgA
e1JKnEpCnEI5pSEYawgAQntzrWtjnAgAMZSMtYyErYR7rZyUtZSMrVpSa1JK
YxAIIUoQWq2lrbWttZyUnIR7hGNaY62crUIIOVIhSjkQKbWlra2UnKWEjHNS
WjkQGIQQIZxjawAAAMDAwCH5BAEAAP8ALAAAAAAZACgAQAj/AP8JHEjwHgsZ
K+ARXMjwnyBd4YKw0TDlzIM54pplasjw0TFKB+iM0KJlAEeCFILgMKBggLJw
hlhB2wTnzgkmPh4Q9ABkg50GqJIZ4tgHGLBENV+U4EgAApwCiSJNGheJT4ST
A/1AqkXHDpshYeA0GuZrEFaBHILMQICIly53Bu48QXKCo7sgOQoouEeuWR+C
m6LN8mPgARQuIAi6u1Ts0Nl/BFI5s0QAa74uaD5EgPNAQOXHAvnAwjYtGDh6
9UbR8lTg8SNjd9wAGYIFw5xEpBM9PkSMUQIEX47w0+ZrD+h/+oSgeraqQIEH
Y5jge8xBSA06CiLIchYsHZ07VozQ/2jN8E+QHgTkEMjFTPe/U8+8wcEz4syW
ewMftAhyz46BoIowpEg0uAhSAAE3FLHUPxAsUAA7x0CAFQHbTBNKAwNcNVAA
gBxHgCGfnUTAF0osIUUWOwhw3ED9qHEHAnUg4EACJh03gB/iuMKNM84008wt
fxzXTTXCRDIAGEysYUAftxDyWCHJyJNDD2kQ8YUfD3wDzSdnESAKOwhEkMMQ
KdwRxyvWqALaIsX8IUcDWDShQh7XgHLcHqjEsgcCBUDhRDuSrOiOPcr8Mkhc
VDhBg4ZnDcBDEBt4A404NanRxA0hMjVDEBwo4MAo0KQChwEkaFHGOyc9sE8Q
FiiQgDrH3JgCTStw0IEBGU1MxxABLgDRgavrhEPKP4NIE8yhDFzBhAoMhfCD
CAq8scgypnzWBzfQNFJTFVvQEGIFzyoghzzIDEsQAbZA0wkcc5jhhA6VxfOD
CQkoEMgxnmQqkB+pRCPqHSRgYcM/8KBwgByBGKOJvgRFAs02e3BW4wAIxEMM
JwwvlIgwuwiC30ADoIJKjWft8ctQKz4WEAA7

------=_NextPart_000_0007_01C2D1E4.831F2400
Content-Type: image/gif;
	name="Cancerribbon.gif"
Content-Transfer-Encoding: base64
Content-ID: <250024123@11022003-33DF>

R0lGODlhGAAoALMAAP////////93vv+Ov/9sr/+Cvv+OwP93r/98vv+HwP97
tv9zsf9tsP9nrwAAAAAAACH5BAEAAAAALAAAAAAYACgAAAS8EMhJR0ol083n
xQXSjZJxZYUgkN2XqStbna9wMLJHpzaeAy6DUKgg5C6NBmA4NMoKyYaCKUzk
okmq8IotUAfcKIMaTjIYiSG4zBB4tz+x+/2TmBeIQnodb7T1cHV+B4BDdQBJ
eVp9SWlkZW+PJFhZWnwdlA2RTJOZDVqBG54AA6Ajo0umoqipX6uUFKAGFJ5K
sZYTrBOluLUdsoiZJKC+I7ycwiyLycOcdlg5zs+2MryXSYehdodLHNTcEQAA
Ow==

------=_NextPart_000_0007_01C2D1E4.831F2400
Content-Type: image/gif;
	name="AIDSribbon.gif"
Content-Transfer-Encoding: base64
Content-ID: <250024123@11022003-33E6>

R0lGODlhGwAoAPcAAP///4SEhIyMjKWlpa2trbW1tb29vcbGxs7OztbW1t7e
3ufn5+/v7/f39/fv78a9vZyUlO/e3r2trbWlpd7GxufOzox7e72lpbWcnNa1
tc6trbWUlIRra6WEhJx7e3NaWpRzc96lpaVzc7V7e4RSUpxaWtZ7e2spKUII
CFIICFoICAgAABAAACEAACkAADEAADkAAEIAAEoAAFIAAGMAAGsAAHMAAIQA
AIwAAJQAAJwAAK0AALUAAM4AANYAAN4AAOcAAPcAAL3Oxs7n3uf/973Wzoyt
pb3n3rXe1qXOxoy1rYStpbXn3pTGva3e1pzOxoy9tXu1rVqUjO/398bOzs7W
1tbe3t7n57W9vaWtra21tYyUlJScnJylpYSMjHN7e+f39+///9bn597v7629
vb3OzpytrYycnNbv74SUlM7n573W1nuMjLXOznOEhK3Gxmt7e97//4ylpYSc
nNb//3uUlMbv75y9vZS1tYytrWN7e63W1oy1tZzOzrXv72OEhHOcnFp7e2uU
lFJzc3utrWOMjFqEhGOUlFKEhEp7e0qEhDl7ezF7exAxMVqEjJSttXuMlJSc
paWlrbWttaWcpXtze4R7hJyEjHtja8attaWMlK2MlHNSWqV7hEIYIb2UnIxj
aykACIxaY6VKWr2MlKVze5Rja5RaY3tKUveMnMZaa71SY61CUpwxQjkIEM6U
nK1ze8aEjKVrc717hIxSWqVaY3tCSrU5SqUhMZwYKc57hLVrc61aY9ZKWnMh
Kd45Ss4xQr0pOXMYIc4pOa0hMVoQGMYhMaUIGPcIIaUAEOcAGO8AGN57hMZr
c7VSWq1KUq1CSpw5QrU5QnshKecxQtYpOYQYIdYhMd4hMdYYKWMIENYQIecQ
IbUIGM4IGNYIGN4IGGMACLUAEMYAENYAEN4AEOdze8ZSWs5SWr1KUrVCSr1C
SsZCSr0xOaUpMdYxOb0pMZwhKYQACJwACKUACO8AEPcAEMYIEO8IELUACL0A
CMYACM4ACOcACO8ACAAAACH5BAEAAI0ALAAAAAAbACgAQAj+AAEIHEgwDC0J
U6YQXMhQ4Ap59np4ENIAAIZ9/uzJ4CWEQUOCY9r4K1evnMl+/oLAIaCg4kcA
YPqZnFkvn716JesBmSVkTMMGaniMG1fOlBcDCwRe8TFyZjkgqih+DBOkhyxH
jgodarSjmhWXL2H28DdynDx59IjW8+etjgGPYeMAwUm3nj19QTooCPMyBBB9
48iRG8dvm5s80kbiJAmkWhWwBBt8IhYJAeSBDBIgOIAlSyRCk75+tKFjHz9+
+WasuRJ2oYN//KydEbKAwRga/uSFon15YaYcdH24sxMDOM4fhQgkfTkGyVx7
gYeSXGuIZW+GdObWLecv0JmWrQH+UADSdLo9ejj95ami8KMCIIIDkyvng/t0
nEA6lek9Bp7QoUCAksZbYgzgT04l+VNKGcsN1MAQPcjEBQJwCWTFE7wEEQQQ
5PkDBBUVCsSAAuCF10ADDDBw3UAz0GCDDTJQMcaKL9FDnoY46rBHg+Gl8o8g
XmwxAAFZuPLPP2VcQeNALMjgzw55ICBQGDvYY88KWjwWlgYxiMNdD02MkQAN
/FjJQy1a8MhQAuTVMw49NhRjA3o4BSFIAWouNAY7QYxEzjzi6ENOehxMGGJD
aHijmFNr1XPGAYf+pEabi3Fnzx+QhgdAGK8cWFc99PizRJ4NhUEeSffRY09K
b5C60A+UMpWDj0mg2jMdOGS4uukPgpUjXT380EVSSk1Y0ZBc8QnGjw+JSKFd
XUBAkWccOgAWnw+IcCFEH0CgmiAQbyiwEANH6DAUOf0YMkACAJCrXTmxAlGs
nmXsMw4QbmhRYgNI/EBeP/2gCwQE4oLUQxCWsDQuAloAcogb7KQURBIlCiRG
FbS9dCIDC1iBABUILHDZkq0FBAA7

------=_NextPart_000_0007_01C2D1E4.831F2400--




From tgl@sss.pgh.pa.us Wed Feb  12 06:18:48 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7F2A74758FE
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 01:18:48 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id CCE21474E5C
	for <pgsql-sql@postgresql.org>; Wed, 12 Feb 2003 01:18:47 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1C6Ij5u001246;
	Wed, 12 Feb 2003 01:18:46 -0500 (EST)
To: "Susan" <brknrose@counterconspiracy.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: adding not null constraints on columns 
In-reply-to: <000601c2d227$91426400$0400a8c0@sd.cox.net> 
References: <000601c2d227$91426400$0400a8c0@sd.cox.net>
Comments: In-reply-to "Susan" <brknrose@counterconspiracy.org>
	message dated "Tue, 11 Feb 2003 15:44:50 -0800"
Date: Wed, 12 Feb 2003 01:18:45 -0500
Message-ID: <1245.1045030725@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/235
X-Sequence-Number: 11633

"Susan" <brknrose@counterconspiracy.org> writes:
> Is there a way to add not null constraints on a column after the column
> has been created?  Any help would be appreciated.  Thanks.

Certainly.  See the ALTER TABLE command.

			regards, tom lane