From: | Matthew <matt(at)ctlno(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Removing NOT NULL Contraint |
Date: | 2000-05-03 16:17:24 |
Message-ID: | 183FA749499ED311B6550000F87E206C0C9163@SRV |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
I may be missing something simple here, but I have an attribute in a
table that was created as NOT NULL. I now need to remove this
constraint. I don't see a proper way to do this. I think I can update
the pg_attribute table and change attnotnull from true to false. Is
this an acceptable solution or is there a good reason that I should not
directly edit the system tables?
Maybe I'm missing something but I didn't see another way to do it other
then creating a new table, selecting into it and dropping the old table,
which seems like a lot of work for something so simple.
Thanks,
Matt
From | Date | Subject | |
---|---|---|---|
Next Message | Todd Turner | 2000-05-03 16:32:57 | database copy and move |
Previous Message | bangh | 2000-05-03 14:08:13 | Re: backup of my database... |
From | Date | Subject | |
---|---|---|---|
Next Message | surfer girl | 2000-05-03 19:23:24 | Re: OID output problems |
Previous Message | The Hermit Hacker | 2000-05-03 15:57:26 | Mail Relay sites ... |