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

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

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> 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 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.

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, May 31, 2024 at 3:10=E2=80=AFAM S=
teve Midgley &lt;<a href=3D"mailto:science@misuse.org">science@misuse.org</=
a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, May =
30, 2024 at 7:25=E2=80=AFAM intmail01 &lt;<a href=3D"mailto:intmail01@gmail=
.com" target=3D"_blank">intmail01@gmail.com</a>&gt; wrote:<br></div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div><=
div>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.</div><div>The same issues for Libreoffice Base interface.</di=
v><div><br></div><div>If I do the operation with command UPDATE then it wor=
ks 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><b=
r></div></div></blockquote><div>This group supports the postgres sql=C2=A0l=
anguage. I think some people here might use pgadmin4 (I don&#39;t), but I t=
hink you&#39;d be better served by the pgadmin <a href=3D"https://www.pgadm=
in.org/support/list/" target=3D"_blank">support list</a> (and <a href=3D"ht=
tps://www.pgadmin.org/docs/pgadmin4/latest/index.html" target=3D"_blank">do=
cs</a>!).=C2=A0</div><div><br></div><div>Steve</div></div></div></blockquot=
e><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>

--000000000000cc93650619b66cda--