Modifying NOT NULL Constraint
Dan Wilson <phppgadmin@acucore.com>
From: "Dan Wilson" <phpPgAdmin@acucore.com>
To: <pgsql-hackers@postgresql.org>
Date: 2000-06-14T03:25:18Z
Lists: pgsql-hackers
In the following archived email: http://www.postgresql.org/mhonarc/pgsql-admin/2000-05/msg00025.html this was posed as a solutions to modifying the NOT NULL constraint: >update pg_attributes set attnotnull = 'f' where oid = oidofnotnullcolumn; >vacuum analyze; I didn't find any further comment on this so I decided to go right to the source... Is this recommended or not? Are there any side effects of which I should be aware before attempting to use this? If this is not a valid way to accomplish the modification of the NOT NULL constraint, then are there plans for an implementation of it (I enjoy the new ALTER COLUMN DEFAULT)? Thanks, -Dan Wilson phpPgAdmin Author http://www.phpwizard.net/phpPgAdmin Please reply to me directly as I'm not subscribed to the list.