MIME-Version: 1.0
References: 
 <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
 <CANVC+RG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg@mail.gmail.com>
In-Reply-To: 
 <CANVC+RG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg@mail.gmail.com>
From: intmail01 <intmail01@gmail.com>
Date: Thu, 30 May 2024 21:01:16 +0300
Message-ID: 
 <CAKJANSAX+4SNMc0gahoMbJds51vTGKM_+8VS2Cf+1cMoNAi8tg@mail.gmail.com>
Subject: Re: Pgadmin 4 cannot add or modify line in a view
To: Usman Khan <umk555@gmail.com>
Cc: pgadmin-hackers@lists.postgresql.org, pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000070b2930619afa280"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSAX%2B4SNMc0gahoMbJds51vTGKM_%2B8VS2Cf%2B1cMoNAi8tg%40mail.gmail.com>
Precedence: bulk

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

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 UPDATE
I checked both source tables and they are well updated.

The reason why Pgadmin locks the array may  come from the fact there is no
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> wrote=
:

>
> Can you please elaborate your requirement a bit more?
> The result grid is usually non editable for views. You can edit table dat=
a
> 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> 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.
>>
>> Thanks
>>
>

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

<div dir=3D"ltr"><div>I read the PostgreSQL manual and view can be modified=
 if some rules are respected. My query is very simple and follow rules : SE=
LECT * FROM thePartionedTable<br></div><div>When I run code with INSERT and=
 UPDATE clause then it work fine.</div><div>In fact the view comes from a p=
artitioned table. After an INSERT or UPDATE I checked both source tables an=
d they are well updated.<br></div><div></div><div><br></div><div>The reason=
 why Pgadmin locks the array may=C2=A0 come from the fact there is no defin=
ed primary key. My partitioned table have primary key.</div><div>I do not h=
ave any idea how to re-define again a primary key for a view.</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">umk555@gmail.com</a>&gt; wrot=
e:<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"l=
tr"><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>

--00000000000070b2930619afa280--