Re: Pgadmin 4 cannot add or modify line in a view

2024-05-30 Thread Usman Khan
Hi, Kindly go through this document for more details about view being non editable https://www.pgadmin.org/docs/pgadmin4/development/editgrid.html On Thu, May 30, 2024 at 10:59 PM intmail01 wrote: > I read the PostgreSQL manual and view can be modified if some rules are > respected. My query is

Re: Pgadmin 4 cannot add or modify line in a view

2024-05-30 Thread intmail01
I read the PostgreSQL manual and view can be modified if some rules are respected. My query is very simple and follow rules : SELECT * FROM thePartionedTable When I run code with INSERT and UPDATE clause then it work fine. In fact the view comes from a partitioned table. After an INSERT or UPDATE I

Re: Pgadmin 4 cannot add or modify line in a view

2024-05-30 Thread Usman Khan
Can you please elaborate your requirement a bit more? The result grid is usually non editable for views. You can edit table data to reflect values in view. Note : adding pgadmin-hackers for more guidance. On Thu, May 30, 2024 at 7:25 PM intmail01 wrote: > Hi, > I tried to modify and add manual