public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Ikram <[email protected]>
To: Amitabh Kant <[email protected]>
Cc: [email protected]
Cc: Steve Midgley <[email protected]>
Cc: intmail01 <[email protected]>
Subject: Re: Pgadmin 4 cannot add or modify line in a view
Date: Fri, 31 May 2024 11:21:12 +0500
Message-ID: <CAGeimVryRqAM7gwFLMUuyZNezGkvbYyHu84YTfqQJDHRmaDfBw@mail.gmail.com> (raw)
In-Reply-To: <CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com>
References: <CAKJANSDszFqovNgpXZFwuCQFZWwLyHh8LaNQPwJwYUJ4w1BvaQ@mail.gmail.com>
	<CAJexoSJty5BCZ6T-ApBe29cqE=jYPjv8Vz=_CQ_Wt0pVVG5F3w@mail.gmail.com>
	<CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com>

Hi,

As mentioned above by Usman, you may add/change data via SQL Tool to view
or underlying table.
There seems to be an issue with PgAdmin, when we right click on *view under
Views *in the tree it shows option view/edit though actually it does not
allow to Add/Edit data.


Regards,
Ikram
Bitnine


On Fri, May 31, 2024 at 7:06 AM Amitabh Kant <[email protected]> wrote:

> On Fri, May 31, 2024 at 3:10 AM Steve Midgley <[email protected]> wrote:
>
>>
>>
>> On Thu, May 30, 2024 at 7:25 AM 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.
>>>
>>> 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.
>


-- 
Muhammad Ikram

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], [email protected]
  Subject: Re: Pgadmin 4 cannot add or modify line in a view
  In-Reply-To: <CAGeimVryRqAM7gwFLMUuyZNezGkvbYyHu84YTfqQJDHRmaDfBw@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