Thread: 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:
Today all my fields are in readonly mode. As this post illustrates:
I tried a reboot of the postgres services. But nothing to do. If anyone could help me ?
Thank a lot.
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