Re: How to disable read-only mode on a table? (superUser)

On 2/16/22 02:30, celati Laurent wrote:
> Good morning,
>
> I created a new table yesterday. I am superuser and I have all the
> rights. I had no worries yesterday to make editions on this table.
> Today all my fields are in readonly mode. As this post illustrates:
>
> https://bytes.com/topic/postgresql/answers/973206-how-remove-read-only-column-sign-postgresql
> <https://bytes.com/topic/postgresql/answers/973206-how-remove-read-only-column-sign-postgresql>
>
> I tried a reboot of the postgres services. But nothing to do. If anyone
> could help me ?

Best bet is you don't have a PRIMARY KEY on the table.

From the screenshot I'm guessing you are using pgAdmin and if I
remember correctly it only allows updates when there is PK field.

Just checked:

https://www.pgadmin.org/docs/pgadmin4/6.5/editgrid.html

"To modify the content of a table, each row in the table must be
uniquely identifiable. If the table definition does not include an OID
or a primary key, the displayed data is read only. Note that views
cannot be edited; updatable views (using rules) are not supported."

> Thank a lot.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com