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
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 |