Updating pg_attribute - Permission denied - Mailing list pgsql-general

From Trewern, Ben
Subject Updating pg_attribute - Permission denied
Date
Msg-id 996802F75C3CD411B424001083FA445B0594E5@CET_PONXX_FP001
Whole thread Raw
Responses Re: Updating pg_attribute - Permission denied  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I was trying to update attnotnull = 't' in the pg_attribute to add Not Null
constraint to a table.  It gave me a Permission denied.

Is this standard? Am I not allowed to change system catalogues (I am using
the postgres superuser!)  I thought I had heard this would work.  Or can you
only change attnotnull to false i.e. remove a not null constraint?  I
suppose this would make some kind of sense, as there could already be Nulls
in the field.

Thanks in advance

Ben

pgsql-general by date:

Previous
From: Steve Heaven
Date:
Subject: Re: Out of memory errors with mod_perl
Next
From: Maurizio Cimaschi
Date:
Subject: Re: updating blobs in Perl with DBD::Pg