Thread: Pgadmin 4 cannot add or modify line in a view
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.
Thanks
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
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.
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.
Regards,
Ikram
Bitnine
On Fri, May 31, 2024 at 7:06 AM Amitabh Kant <amitabhkant@gmail.com> wrote:
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!).SteveI 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.
Muhammad Ikram
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.Regards,IkramBitnineOn Fri, May 31, 2024 at 7:06 AM Amitabh Kant <amitabhkant@gmail.com> wrote: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!).SteveI 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.--Muhammad Ikram