public inbox for [email protected]help / color / mirror / Atom feed
Pgadmin 4 cannot add or modify line in a view 8+ messages / 5 participants [nested] [flat]
* Pgadmin 4 cannot add or modify line in a view @ 2024-05-30 14:26 intmail01 <[email protected]> 2024-05-30 14:52 ` Re: Pgadmin 4 cannot add or modify line in a view Usman Khan <[email protected]> 2024-05-30 21:40 ` Re: Pgadmin 4 cannot add or modify line in a view Steve Midgley <[email protected]> 0 siblings, 2 replies; 8+ messages in thread From: intmail01 @ 2024-05-30 14:26 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> @ 2024-05-30 14:52 ` Usman Khan <[email protected]> 2024-05-30 18:01 ` Re: Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 1 sibling, 1 reply; 8+ messages in thread From: Usman Khan @ 2024-05-30 14:52 UTC (permalink / raw) To: intmail01 <[email protected]>; [email protected]; +Cc: [email protected] 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 <[email protected]> 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. > > Thanks > ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 14:52 ` Re: Pgadmin 4 cannot add or modify line in a view Usman Khan <[email protected]> @ 2024-05-30 18:01 ` intmail01 <[email protected]> 2024-05-30 19:07 ` Re: Pgadmin 4 cannot add or modify line in a view Usman Khan <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: intmail01 @ 2024-05-30 18:01 UTC (permalink / raw) To: Usman Khan <[email protected]>; +Cc: [email protected]; [email protected] 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 checked both source tables and they are well updated. The reason why Pgadmin locks the array may come from the fact there is no defined primary key. My partitioned table have primary key. I do not have any idea how to re-define again a primary key for a view. Thanks On Thu, May 30, 2024 at 5:52 PM Usman Khan <[email protected]> wrote: > > 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 <[email protected]> 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. >> >> Thanks >> > ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 14:52 ` Re: Pgadmin 4 cannot add or modify line in a view Usman Khan <[email protected]> 2024-05-30 18:01 ` Re: Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> @ 2024-05-30 19:07 ` Usman Khan <[email protected]> 0 siblings, 0 replies; 8+ messages in thread From: Usman Khan @ 2024-05-30 19:07 UTC (permalink / raw) To: intmail01 <[email protected]>; +Cc: [email protected]; [email protected] 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 <[email protected]> wrote: > 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 checked both source tables and they are well updated. > > The reason why Pgadmin locks the array may come from the fact there is no > defined primary key. My partitioned table have primary key. > I do not have any idea how to re-define again a primary key for a view. > > Thanks > > On Thu, May 30, 2024 at 5:52 PM Usman Khan <[email protected]> wrote: > >> >> 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 <[email protected]> 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. >>> >>> Thanks >>> >> ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> @ 2024-05-30 21:40 ` Steve Midgley <[email protected]> 2024-05-31 02:05 ` Re: Pgadmin 4 cannot add or modify line in a view Amitabh Kant <[email protected]> 1 sibling, 1 reply; 8+ messages in thread From: Steve Midgley @ 2024-05-30 21:40 UTC (permalink / raw) To: intmail01 <[email protected]>; +Cc: [email protected] On Thu, May 30, 2024 at 7:25 AM intmail01 <[email protected]> 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 <https://www.pgadmin.org/support/list/; (and docs <https://www.pgadmin.org/docs/pgadmin4/latest/index.html;!). Steve ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 21:40 ` Re: Pgadmin 4 cannot add or modify line in a view Steve Midgley <[email protected]> @ 2024-05-31 02:05 ` Amitabh Kant <[email protected]> 2024-05-31 06:21 ` Re: Pgadmin 4 cannot add or modify line in a view Muhammad Ikram <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Amitabh Kant @ 2024-05-31 02:05 UTC (permalink / raw) To: [email protected]; +Cc: Steve Midgley <[email protected]>; intmail01 <[email protected]> On Fri, May 31, 2024 at 3:10 AM Steve Midgley <[email protected]> wrote: > > > On Thu, May 30, 2024 at 7:25 AM intmail01 <[email protected]> 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 <https://www.pgadmin.org/support/list/; (and docs > <https://www.pgadmin.org/docs/pgadmin4/latest/index.html;!). > > 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. ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 21:40 ` Re: Pgadmin 4 cannot add or modify line in a view Steve Midgley <[email protected]> 2024-05-31 02:05 ` Re: Pgadmin 4 cannot add or modify line in a view Amitabh Kant <[email protected]> @ 2024-05-31 06:21 ` Muhammad Ikram <[email protected]> 2024-05-31 15:33 ` Re: Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 0 siblings, 1 reply; 8+ messages in thread From: Muhammad Ikram @ 2024-05-31 06:21 UTC (permalink / raw) To: Amitabh Kant <[email protected]>; +Cc: [email protected]; Steve Midgley <[email protected]>; intmail01 <[email protected]> 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 <[email protected]> wrote: > On Fri, May 31, 2024 at 3:10 AM Steve Midgley <[email protected]> wrote: > >> >> >> On Thu, May 30, 2024 at 7:25 AM intmail01 <[email protected]> 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 <https://www.pgadmin.org/support/list/; (and docs >> <https://www.pgadmin.org/docs/pgadmin4/latest/index.html;!). >> >> 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. > -- Muhammad Ikram ^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Pgadmin 4 cannot add or modify line in a view 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 21:40 ` Re: Pgadmin 4 cannot add or modify line in a view Steve Midgley <[email protected]> 2024-05-31 02:05 ` Re: Pgadmin 4 cannot add or modify line in a view Amitabh Kant <[email protected]> 2024-05-31 06:21 ` Re: Pgadmin 4 cannot add or modify line in a view Muhammad Ikram <[email protected]> @ 2024-05-31 15:33 ` intmail01 <[email protected]> 0 siblings, 0 replies; 8+ messages in thread From: intmail01 @ 2024-05-31 15:33 UTC (permalink / raw) To: Muhammad Ikram <[email protected]>; +Cc: Amitabh Kant <[email protected]>; [email protected]; Steve Midgley <[email protected]> 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 <[email protected]> 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, > Ikram > Bitnine > > > On Fri, May 31, 2024 at 7:06 AM Amitabh Kant <[email protected]> > wrote: > >> On Fri, May 31, 2024 at 3:10 AM Steve Midgley <[email protected]> wrote: >> >>> >>> >>> On Thu, May 30, 2024 at 7:25 AM intmail01 <[email protected]> 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 <https://www.pgadmin.org/support/list/; (and docs >>> <https://www.pgadmin.org/docs/pgadmin4/latest/index.html;!). >>> >>> 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. >> > > > -- > Muhammad Ikram > > ^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2024-05-31 15:33 UTC | newest] Thread overview: 8+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-05-30 14:26 Pgadmin 4 cannot add or modify line in a view intmail01 <[email protected]> 2024-05-30 14:52 ` Usman Khan <[email protected]> 2024-05-30 18:01 ` intmail01 <[email protected]> 2024-05-30 19:07 ` Usman Khan <[email protected]> 2024-05-30 21:40 ` Steve Midgley <[email protected]> 2024-05-31 02:05 ` Amitabh Kant <[email protected]> 2024-05-31 06:21 ` Muhammad Ikram <[email protected]> 2024-05-31 15:33 ` intmail01 <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox