Partitioned table is in fact a view with a 'WHERE' clause. I create a view under a view.
But curiously I can modify the source table by applying INSERT or UPDATE clause with sql code on the view. SQL code works, not GUI.
Thanks for all !
On Fri, May 31, 2024 at 9:21 AM Muhammad Ikram <mmikram@gmail.com> wrote:
Hi,
As mentioned above by Usman, you may add/change data via SQL Tool to view or underlying table.
There seems to be an issue with PgAdmin, when we right click on view under Views in the tree it shows option view/edit though actually it does not allow to Add/Edit data.
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.
