Probleme on ALTER

Hello !

I have this table :

Attribute | Type | Modifier
-----------------+--------------+---------------------------------------
ref | integer | default nextval('cvdb_ref_seq'::text)
nom | varchar(50) |
prenom | varchar(50) |
email | varchar(100) |
password | varchar(20) |

but i forgot to do "NOT NULL" on the fields.

I try ALTER table ALTER COLUMN ref ADD CONSTRAINT NOT NULL but it doesn't work.

Does someone have the right solution ?

thanks for answer.

--

Mickaël JOUANNE
Webmaster / Developpeur / Support Technique

APR-Job &
www.jobscout24.fr - Meet your future
_____________________________________

HumanLine France SAS
32, rue Pierret
92200 Neuilly

tel: +33 1 42 44 40 73
fax: +33 1 49 26 09 76
ICQ: 42799256
m(dot)jouanne(at)humanline(dot)fr