[SOLVED] Issue with py-PostgreSQL [windows,python3]

aihaike · 03-12-2018, 05:27 AM

Dear all,

I use Python package pyPostgreSQL to do some 'select' and 'set' on my DB. It's been working without any issue so far.
However, at one line in the code I get a weird error.

Here is the line:

Code:

dbh_query( "UPDATE public.\"tablename\" SET flag='2', first_data_name=\'%s\',dist=\'%s\' WHERE second_data_name=\'%s\'" % (l_1,l_index,l_0) )

And here the message:

Code:

TypeError: 'list' object is not callable

I replaced dbh_query by print to see what I was querying but the data looks correct.

I just can't figure what's wrong, why the previous similar queries works just fine but not that one especially.

I'm using Python 3.6.4 under Windows 12.

Any help would be appreciated.
Thank you.

aihaike · 03-12-2018, 08:01 AM

I just realized my mistake.

I import the module this way :

Code:

from pg import DB

Actually the line

Code:

dbh.query( "UPDATE public.\"tablename\" SET flag='2', first_data_name=\'%s\',dist=\'%s\' WHERE second_data_name=\'%s\'" % (l_1,l_index,l_0) )

For some reason became

Code:

dbh_query( "UPDATE public.\"tablename\" SET flag='2', first_data_name=\'%s\',dist=\'%s\' WHERE second_data_name=\'%s\'" % (l_1,l_index,l_0) )

So, the error message was making sense since this is a variable of type list in my code.