Minor issue

From: Frank Millman <frank(at)chagford(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Minor issue
Date: 2020-05-26 11:42:56
Message-ID: 92a25cd6-5b50-3074-0da6-7394db9e0f0a@chagford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi all

This is very minor, but I thought I would mention it.

I have a function that returns a complex SQL query and a tuple of
parameters. The query is stored inside the function as a triple-quoted
string, and the parameters are derived depending on the input arguments.

Sometimes while testing I will comment out some of the SQL using '--'.
If those lines happen to contain a parameter placeholder ('%s') I
expected to remove the parameter from the tuple as well.

pyodbc and sqlite3 both work this way, but psycopg2 raises the exception
'tuple index out of range'.

I can live with it, but it means that I have to adjust the parameter
tuple differently depending on which database I am testing with.

If it can be fixed, that would be nice. If it can't, no problem.

Frank Millman

Responses

Browse psycopg by date

  From Date Subject
Next Message Rory Campbell-Lange 2020-05-26 11:45:41 Re: Minor issue
Previous Message Daniele Varrazzo 2020-05-20 08:15:04 psycopg3 performance article