On Tue, 20 Jan 2004, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> 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.
So, if we replace that with: ALTER TABLE table_name ALTER column_name DROP NOT NULL; ? should be good to go? still not as clean as doing the straight DROP COLUMN, but its a fast fix ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
