MIME-Version: 1.0
References: 
 <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
 <CAJexoSJty5BCZ6T-ApBe29cqE=jYPjv8Vz=_CQ_Wt0pVVG5F3w@mail.gmail.com>
 <CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com>
In-Reply-To: 
 <CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com>
From: Muhammad Ikram <mmikram@gmail.com>
Date: Fri, 31 May 2024 11:21:12 +0500
Message-ID: 
 <CAGeimVryRqAM7gwFLMUuyZNezGkvbYyHu84YTfqQJDHRmaDfBw@mail.gmail.com>
Subject: Re: Pgadmin 4 cannot add or modify line in a view
To: Amitabh Kant <amitabhkant@gmail.com>
Cc: pgsql-sql@lists.postgresql.org, Steve Midgley <science@misuse.org>,
	intmail01 <intmail01@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000a1bcb00619b9fed2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGeimVryRqAM7gwFLMUuyZNezGkvbYyHu84YTfqQJDHRmaDfBw%40mail.gmail.com>
Precedence: bulk

--000000000000a1bcb00619b9fed2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 <amitabhkant@gmail.com=
> wrote:

> On Fri, May 31, 2024 at 3:10=E2=80=AFAM Steve Midgley <science@misuse.org=
> wrote:
>
>>
>>
>> On Thu, May 30, 2024 at 7:25=E2=80=AFAM 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 lin=
e 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 tha=
n
> the views supported by postgres SQL language. If that's the case, you mig=
ht
> be missing a primary key in your table.
>


--=20
Muhammad Ikram

--000000000000a1bcb00619b9fed2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>As mentioned above by Usman, you ma=
y add/change data via SQL Tool to view or underlying table.=C2=A0</div><div=
>There seems to be an issue with PgAdmin, when we right click on <b>view un=
der Views </b>in the tree it shows option view/edit though actually it does=
 not allow to Add/Edit data.</div><div><br></div><div><br></div><div>Regard=
s,</div><div>Ikram</div><div>Bitnine</div><div><br></div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, May 31, 20=
24 at 7:06=E2=80=AFAM Amitabh Kant &lt;<a href=3D"mailto:amitabhkant@gmail.=
com">amitabhkant@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Fri, May 31,=
 2024 at 3:10=E2=80=AFAM Steve Midgley &lt;<a href=3D"mailto:science@misuse=
.org" target=3D"_blank">science@misuse.org</a>&gt; wrote:<br></div><div cla=
ss=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Thu, May 30, 2024 at 7:25=E2=80=AFAM int=
mail01 &lt;<a href=3D"mailto:intmail01@gmail.com" target=3D"_blank">intmail=
01@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex"><div dir=3D"ltr"><div>Hi,</div><div>I tried to modify and add m=
anuallly a line in a view with pgadmin4 but the interface doesnt allow it b=
ecause cells are locked and no empty line to add new one.</div><div>The sam=
e issues for Libreoffice Base interface.</div><div><br></div><div>If I do t=
he operation with command UPDATE then it works well .<br></div><div>How to =
permit pgadmin4 to not lock the interface ?</div><div></div><div><br></div>=
<div>I run postgresql 14.1.<br></div><div><br></div></div></blockquote><div=
>This group supports the postgres sql=C2=A0language. I think some people he=
re might use pgadmin4 (I don&#39;t), but I think you&#39;d be better served=
 by the pgadmin <a href=3D"https://www.pgadmin.org/support/list/" target=3D=
"_blank">support list</a> (and <a href=3D"https://www.pgadmin.org/docs/pgad=
min4/latest/index.html" target=3D"_blank">docs</a>!).=C2=A0</div><div><br><=
/div><div>Steve</div></div></div></blockquote><div><br></div><div>I assume =
you are talking about the table data view in pgadmin, rather than the views=
 supported by postgres SQL=C2=A0language. If that&#39;s the case, you might=
 be missing a primary key in your table.=C2=A0 =C2=A0</div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>

--000000000000a1bcb00619b9fed2--