From: | intmail01 <intmail01(at)gmail(dot)com> |
---|---|
To: | Muhammad Ikram <mmikram(at)gmail(dot)com> |
Cc: | Amitabh Kant <amitabhkant(at)gmail(dot)com>, pgsql-sql(at)lists(dot)postgresql(dot)org, Steve Midgley <science(at)misuse(dot)org> |
Subject: | Re: Pgadmin 4 cannot add or modify line in a view |
Date: | 2024-05-31 15:33:01 |
Message-ID: | CAKJANSA2z4ewbsta3oWXORxmVW10AZ-8vZWAFZi+ZMQBTRnfKQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgsql-sql |
Partitioned table is in fact a view with a 'WHERE' clause. I create a view
under a view.
But curiously I can modify the source table by applying INSERT or UPDATE
clause with sql code on the view. SQL code works, not GUI.
Thanks for all !
On Fri, May 31, 2024 at 9:21 AM Muhammad Ikram <mmikram(at)gmail(dot)com> wrote:
> 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 <amitabhkant(at)gmail(dot)com>
> wrote:
>
>> 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.
>>
>
>
> --
> Muhammad Ikram
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2024-05-31 22:09:22 | Re: Potential Security Issue: Permissions in PgAdmin Installation Directory |
Previous Message | Usman Khan | 2024-05-31 06:24:44 | Messages held for moderation |
From | Date | Subject | |
---|---|---|---|
Next Message | Kanimozhi Manoharan | 2024-06-03 05:26:07 | Re: Postgres fine tuning |
Previous Message | Muhammad Ikram | 2024-05-31 06:21:12 | Re: Pgadmin 4 cannot add or modify line in a view |