Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sD4FN-009vXT-SZ for pgsql-sql@arkaria.postgresql.org; Fri, 31 May 2024 15:32:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sD4EO-00CkO3-SO for pgsql-sql@arkaria.postgresql.org; Fri, 31 May 2024 15:31:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sD4EO-00CkNv-Fm for pgsql-sql@lists.postgresql.org; Fri, 31 May 2024 15:31:48 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sD4EH-001gzU-79 for pgsql-sql@lists.postgresql.org; Fri, 31 May 2024 15:31:47 +0000 Received: by mail-ot1-x335.google.com with SMTP id 46e09a7af769-6f8e012e51dso1371930a34.1 for ; Fri, 31 May 2024 08:31:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717169500; x=1717774300; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=aU9ys8Q4IJOG+usvgl44xnXYC4Tr/AdIugI9w72n9ac=; b=LQdUq8Nmrr3N9rPqJ7LLek0Ocrho1+b/CjHGaSVtCwgZieLefky2fjb03z9DNWxYt9 v7GZc7bbYA2d6G7TOThvdW+MFj1cUhK3LMkSmhsqB9FD/MgBDI+t7bjhhIAXrj+ZpiNa 8L4diQE+it1SxkXeTK4y8L5qgZRpC/WW7bTjou/5H8IVWM/DIrutKiEQsKJTYdFhjgN4 T5Ro8P3KJHpHmPCN2BkvoVOKjje5jZIlkLCg5Vk2bhkg5YRIYAVipFO0GAI1g4LFt/ZH d8vKEUUdFCesbkZEdDtdYByo+FuzhLImfqzf2zEKGnufLY8FmndOo0Ry5bsABmTvnKxy JV9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717169500; x=1717774300; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=aU9ys8Q4IJOG+usvgl44xnXYC4Tr/AdIugI9w72n9ac=; b=nCmlOzWnkx4SeZVh4X19HOTfLuu8ZfueFLmwniwkfaW8xKYiaw3jtcdGHiEOVm52Ub giMYhRG83/PDrQ4vb1yX+3CfJLvtm3uCh3bc9M78dxkj9VqsAtYlp8xlPD+Td7iIef4r Llv8xP5hxLwwhlPcxCwStIhI88Xxfc0gQnM5juVWPP1SuBBIPIhP2p0pHoJ0X41CQFPn 7rmR7SyJy1JoLnmTHPfaD3yTbCYL86cPZ+Jtutx/DK5Guii00on22duaLmX7hcKP1t99 AmL3rlkZmCJM9s5tzXH7sz0Doku8mYcsCEcItwJMLJbq48i7Tzrkmrch19fy6OSF4y2c gXtw== X-Forwarded-Encrypted: i=1; AJvYcCW70O1rYrsQzjAoSCH2sswwc9XyaC5VpoaASORUbliJqFQq/K6TdvjsN4qEy/zCewcFJpH8ZGbwfiASeNWmu09M6rzSHgnxeTRaVcusbQo= X-Gm-Message-State: AOJu0Yyh5OJKbCvGGrtIwYQAJBzZz+P062dUaEGS0DP39+uvV77hGZi3 AECh38njIYlwa6P+6csWIam1xZRD7/8kF5LCtawPVyFr38mReoDogcOfk4uzXrEqGvLwdca/kG7 mXd6RGnE9yEpAYnh8du0XoD/E8BU//jm5 X-Google-Smtp-Source: AGHT+IHgTGjmcIofIfOrJM0+ErKSe084DJfNeMOjmpwMIEBt7bAgXIxNSfSzHbXk1B2F4XNiDzp5UL4dbm1YzInhdsc= X-Received: by 2002:a05:6870:d626:b0:250:6a57:1088 with SMTP id 586e51a60fabf-2508bfb46cemr2137843fac.44.1717169499334; Fri, 31 May 2024 08:31:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: intmail01 Date: Fri, 31 May 2024 18:33:01 +0300 Message-ID: Subject: Re: Pgadmin 4 cannot add or modify line in a view To: Muhammad Ikram Cc: Amitabh Kant , pgsql-sql@lists.postgresql.org, Steve Midgley Content-Type: multipart/alternative; boundary="00000000000006f39e0619c1ae28" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000006f39e0619c1ae28 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFAM Muhammad Ikram = 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=E2=80=AFAM Amitabh Kant > wrote: > >> On Fri, May 31, 2024 at 3:10=E2=80=AFAM Steve Midgley wrote: >> >>> >>> >>> On Thu, May 30, 2024 at 7:25=E2=80=AFAM intmail01 = 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 li= ne 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 her= e >>> 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, y= ou >> might be missing a primary key in your table. >> > > > -- > Muhammad Ikram > > --00000000000006f39e0619c1ae28 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Partitioned table is in fact a view with a 'WHERE= ' clause. I create a view under a view.
But curiously I can m= odify 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=E2=80=AFAM Muhammad Ikram <mmikram@gmail.com> wrote:
Hi,

= As mentioned above by Usman, you may add/change data via SQL Tool to view o= r underlying table.=C2=A0
There seems to be an issue with PgAdmin= , when we right click on view under Views in the tree it shows optio= n view/edit though actually it does not allow to Add/Edit data.
<= br>

Regards,
Ikram
Bitnine


On Fri, May 31, 2024 at 7:06=E2=80=AFAM Amitabh Kant <<= a href=3D"mailto:amitabhkant@gmail.com" target=3D"_blank">amitabhkant@gmail= .com> wrote:
On Fri, May 31, 2024 at 3:10=E2=80=AF= AM Steve Midgley <science@misuse.org> wrote:


On Thu, May 30, 2024 at 7:25=E2=80=AFAM intmail01 <intmail01@gmail.com> w= rote:
Hi,
I tried to modify and add manuallly a line in a= view with pgadmin4 but the interface doesnt allow it because cells are loc= ked and no empty line to add new one.
The same issues for Libreof= fice Base interface.

If I do the operation with co= mmand UPDATE then it works well .
How to permit pgadmin4 to n= ot lock the interface ?

I run postgresq= l 14.1.

This group supports= the postgres sql=C2=A0language. I think some people here might use pgadmin= 4 (I don't), but I think you'd be better served by the pgadmin support lis= t (and docs!).=C2=A0

Steve

I assume you are talking abou= t the table data view in pgadmin, rather than the views supported by postgr= es SQL=C2=A0language. If that's the case, you might be missing a primar= y key in your table.=C2=A0 =C2=A0


--
Muhammad Ikram

--00000000000006f39e0619c1ae28--