"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> On Mon, 19 Jan 2004, Tom Lane wrote:
>> in particular, what SQL command is it trying to execute when it chokes?
> The function is executing:
> EXECUTE ''update pg_attribute set attnotnull = false from pg_class where
> pg_attribute.attrelid = pg_class.oid and pg_class.relname = '' ||
> quote_literal(table_name) ||'' and pg_attribute.attname = '' ||
> quote_literal(column_name);
Well, no wonder. You have to be superuser to do that, and it's a pretty
bad idea even then.
We do have ALTER TABLE ... SET/DROP NOT NULL since 7.3, so hacking
pg_attribute directly isn't necessary for this anymore.
regards, tom lane