Re: PGAdmin4.11.1 on Ubuntu 18.04

On 8/1/19 9:05 AM, Daniele Varrazzo wrote:
> On Thu, Aug 1, 2019 at 4:43 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> Yeah the requirements file shows psycopg2-2.8:
>> https://github.com/postgres/pgadmin4/blob/master/requirements.txt
>>
>> The issue(I'm assuming) is:
>>
>> http://initd.org/psycopg/articles/2019/04/04/psycopg-28-released/
>> "Added table_oid and table_column attributes on cursor.description items
>> (ticket #661)."
>
> Couldn't be pgadmin forgiving if these attributes are not available?

Looks like it is wrapped up in this:

https://www.pgadmin.org/docs/pgadmin4/4.11/release_notes_4_11.html
Issue #1760 - Add support for editing of resultsets in the Query Tool,
if the data can be identified as updatable.

https://redmine.postgresql.org/issues/1760

def check_updatable_results_pkeys(self):

"""

This function is used to check whether the last successful query
produced updatable results and sets the necessary flags and
attributes accordingly. Should be called after polling for the
results is successful(results are ready)

"""

...

self.is_updatable_resultset, self.primary_keys, pk_names,table_oid = \
is_query_resultset_updatable(conn, sql_path)

>
> -- Daniele
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com