MIME-Version: 1.0
References: 
 <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
In-Reply-To: 
 <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
From: Usman Khan <umk555@gmail.com>
Date: Thu, 30 May 2024 19:52:02 +0500
Message-ID: 
 <CANVC+RG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg@mail.gmail.com>
Subject: Re: Pgadmin 4 cannot add or modify line in a view
To: intmail01 <intmail01@gmail.com>, pgadmin-hackers@lists.postgresql.org
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003ba32e0619ad0365"
Archived-At: 
 <https://www.postgresql.org/message-id/CANVC%2BRG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg%40mail.gmail.com>
Precedence: bulk

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

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=E2=80=AFPM intmail01 <intmail01@gmail.com> wro=
te:

> Hi,
> I tried to modify and add manuallly a line in a view with pgadmin4 but th=
e
> interface doesnt allow it because cells are locked and no empty line to a=
dd
> 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
>

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

<div dir=3D"ltr"><div><br></div><div>
Can you please elaborate your requirement a bit more?

</div><div>The result grid is usually non editable for views. You can edit =
table data to reflect values in view.</div><div><br></div><div>
<div>Note : adding pgadmin-hackers for more guidance.<br></div><br></div></=
div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On=
 Thu, May 30, 2024 at 7:25=E2=80=AFPM intmail01 &lt;<a href=3D"mailto:intma=
il01@gmail.com">intmail01@gmail.com</a>&gt; wrote:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div><div>I tr=
ied to modify and add manuallly a line in a view with pgadmin4 but the inte=
rface doesnt allow it because cells are locked and no empty line to add new=
 one.</div><div>The same issues for Libreoffice Base interface.</div><div><=
br></div><div>If I do the operation with command UPDATE then it works well =
.<br></div><div>How to permit pgadmin4 to not lock the interface ?</div><di=
v></div><div><br></div><div>I run postgresql 14.1.<br></div><div><br></div>=
<div>Thanks<br></div></div>
</blockquote></div>

--0000000000003ba32e0619ad0365--