MIME-Version: 1.0
References: 
 <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
 <CANVC+RG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg@mail.gmail.com>
 <CAKJANSAX+4SNMc0gahoMbJds51vTGKM_+8VS2Cf+1cMoNAi8tg@mail.gmail.com>
In-Reply-To: 
 <CAKJANSAX+4SNMc0gahoMbJds51vTGKM_+8VS2Cf+1cMoNAi8tg@mail.gmail.com>
From: Usman Khan <umk555@gmail.com>
Date: Fri, 31 May 2024 00:07:15 +0500
Message-ID: 
 <CANVC+REhLN4cGOLMTyYBrpY=G6dAfxx33dZNLwshELJFdq_tGQ@mail.gmail.com>
Subject: Re: Pgadmin 4 cannot add or modify line in a view
To: intmail01 <intmail01@gmail.com>
Cc: pgadmin-hackers@lists.postgresql.org, pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e700270619b093ba"
Archived-At: 
 <https://www.postgresql.org/message-id/CANVC%2BREhLN4cGOLMTyYBrpY%3DG6dAfxx33dZNLwshELJFdq_tGQ%40mail.gmail.com>
Precedence: bulk

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

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

> 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 UPDAT=
E
> I checked both source tables and they are well updated.
>
> The reason why Pgadmin locks the array may  come from the fact there is n=
o
> 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=E2=80=AFPM Usman Khan <umk555@gmail.com> wro=
te:
>
>>
>> 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> =
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.
>>>
>>> Thanks
>>>
>>

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

<div dir=3D"ltr"><div>Hi,</div><div>Kindly go through this document for mor=
e details about view being non editable<br></div><div><a href=3D"https://ww=
w.pgadmin.org/docs/pgadmin4/development/editgrid.html">https://www.pgadmin.=
org/docs/pgadmin4/development/editgrid.html</a></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, May 30, 2024=
 at 10:59=E2=80=AFPM intmail01 &lt;<a href=3D"mailto:intmail01@gmail.com">i=
ntmail01@gmail.com</a>&gt; wrote:<br></div><blockquote class=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>I read the PostgreSQL manual and vi=
ew can be modified if some rules are respected. My query is very simple and=
 follow rules : SELECT * FROM thePartionedTable<br></div><div>When I run co=
de with INSERT and UPDATE clause then it work fine.</div><div>In fact the v=
iew comes from a partitioned table. After an INSERT or UPDATE I checked bot=
h source tables and they are well updated.<br></div><div></div><div><br></d=
iv><div>The reason why Pgadmin locks the array may=C2=A0 come from the fact=
 there is no defined primary key. My partitioned table have primary key.</d=
iv><div>I do not have any idea how to re-define again a primary key for a v=
iew.</div><div><br></div><div>Thanks<br></div></div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, May 30, 2024 at 5:52=
=E2=80=AFPM Usman Khan &lt;<a href=3D"mailto:umk555@gmail.com" target=3D"_b=
lank">umk555@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><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" target=3D"_blank">intmail01@gmail.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px 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 pga=
dmin4 but the interface doesnt allow it because cells are locked and no emp=
ty line to add new one.</div><div>The same issues for Libreoffice Base inte=
rface.</div><div><br></div><div>If I do the operation with command UPDATE t=
hen it works well .<br></div><div>How to permit pgadmin4 to not lock the in=
terface ?</div><div></div><div><br></div><div>I run postgresql 14.1.<br></d=
iv><div><br></div><div>Thanks<br></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>

--000000000000e700270619b093ba--