From: | Amitabh Kant <amitabhkant(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Cc: | Steve Midgley <science(at)misuse(dot)org>, intmail01 <intmail01(at)gmail(dot)com> |
Subject: | Re: Pgadmin 4 cannot add or modify line in a view |
Date: | 2024-05-31 02:05:23 |
Message-ID: | CAPTAQB+F2GAd2ZkXdJSfbf9_Lu5=dDg_Bp4pRz31ZMatXmeB5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgsql-sql |
On Fri, May 31, 2024 at 3:10 AM Steve Midgley <science(at)misuse(dot)org> wrote:
>
>
> On Thu, May 30, 2024 at 7:25 AM intmail01 <intmail01(at)gmail(dot)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 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Qasim Tahir | 2024-05-31 06:17:27 | Potential Security Issue: Permissions in PgAdmin Installation Directory |
Previous Message | Steve Midgley | 2024-05-30 21:40:19 | Re: Pgadmin 4 cannot add or modify line in a view |
From | Date | Subject | |
---|---|---|---|
Next Message | Kanimozhi Manoharan | 2024-05-31 05:42:19 | Postgres fine tuning |
Previous Message | Steve Midgley | 2024-05-30 21:40:19 | Re: Pgadmin 4 cannot add or modify line in a view |