public inbox for [email protected]  

help / color / mirror / Atom feed

From: Usman Khan <[email protected]>
To: intmail01 <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Pgadmin 4 cannot add or modify line in a view
Date: Fri, 31 May 2024 00:07:15 +0500
Message-ID: <CANVC+REhLN4cGOLMTyYBrpY=G6dAfxx33dZNLwshELJFdq_tGQ@mail.gmail.com> (raw)
In-Reply-To: <CAKJANSAX+4SNMc0gahoMbJds51vTGKM_+8VS2Cf+1cMoNAi8tg@mail.gmail.com>
References: <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
	<CANVC+RG9AVdSsCoJA_C8JF9WuMNP_9WYVSiP7_fRw6KtJR2qZg@mail.gmail.com>
	<CAKJANSAX+4SNMc0gahoMbJds51vTGKM_+8VS2Cf+1cMoNAi8tg@mail.gmail.com>

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 PM intmail01 <[email protected]> wrote:

> 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 PM Usman Khan <[email protected]> wrote:
>
>>
>> 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 PM intmail01 <[email protected]> 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 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
>>>
>>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Pgadmin 4 cannot add or modify line in a view
  In-Reply-To: <CANVC+REhLN4cGOLMTyYBrpY=G6dAfxx33dZNLwshELJFdq_tGQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox