How to disable read-only mode on a table? (superUser)
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
I tried a reboot of the postgres services. But nothing to do. If anyone
could help me ?
Thank a lot.
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.klaver@aklaver.com