To: psycopg@postgresql.org
From: Frank Millman <frank@chagford.com>
Subject: Minor issue
Message-ID: <92a25cd6-5b50-3074-0da6-7394db9e0f0a@chagford.com>
Date: Tue, 26 May 2020 13:42:56 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101
 Thunderbird/68.8.1
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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