Re: Pgadmin 4 cannot add or modify line in a view - Mailing list pgsql-sql

From Amitabh Kant
Subject Re: Pgadmin 4 cannot add or modify line in a view
Date
Msg-id CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com
Whole thread Raw
In response to Re: Pgadmin 4 cannot add or modify line in a view  (Steve Midgley <science@misuse.org>)
Responses Re: Pgadmin 4 cannot add or modify line in a view
List pgsql-sql
On Fri, May 31, 2024 at 3:10 AM Steve Midgley <science@misuse.org> wrote:


On Thu, May 30, 2024 at 7:25 AM intmail01 <intmail01@gmail.com> wrote:
Hi,
I tried to modify and add manuallly a line in a view with pgadmin4 but the interface doesnt allow it because cells are locked and no empty line to add new one.
The same issues for Libreoffice Base interface.

If I do the operation with command UPDATE then it works well .
How to permit pgadmin4 to not lock the interface ?

I run postgresql 14.1.

This group supports the postgres sql language. I think some people here might use pgadmin4 (I don't), but I think you'd be better served by the pgadmin support list (and docs!). 

Steve

I assume you are talking about the table data view in pgadmin, rather than the views supported by postgres SQL language. If that's the case, you might be missing a primary key in your table.   

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: Pgadmin 4 cannot add or modify line in a view
Next
From: Kanimozhi Manoharan
Date:
Subject: Postgres fine tuning