[Pypgsql-devel] [ pypgsql-Bugs-879531 ] Does not handle select into properly

[SourceForge.net <no...@so...>]

Bugs item #879531, was opened at 2004-01-18 18:54
Message generated for change (Settings changed) made by ballie01
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=879531&group_id=16528

Category: PgSQL
Group: None
>Status: Pending
>Resolution: Fixed
Priority: 7
Submitted By: Ben Burton (bab)
Assigned to: Billy G. Allie (ballie01)
Summary: Does not handle select into properly

Initial Comment:
(Received through the Debian BTS as #226946) 
 
There is a bug in the execute method when dealing with select 
into queries: it checks using a simple regexp if a select 
statement is about to be executed and if so it will declare a 
cursor. This does not work for select into queries, which do not 
support cursors. Unfortunately the current approach of using a 
regexp to check for exceptions does not work very well since it is 
not possible to reliable check for select into statements without 
parsing the statement. 
 
Thanks - Ben. 

----------------------------------------------------------------------

Comment By: Billy G. Allie (ballie01)
Date: 2004-01-18 21:31

Message:
Logged In: YES 
user_id=8500

The work around for the problem is to turn off the use of
PostgreSQL portals.

I will modify the code so that portals are not used both
select and into are used in the same query.

Yes, i know that there can be false positives (ie into is
used in a string in the query), but at worse, a portal will
not be used in this instance.  For the application point of
view, there is no difference.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=879531&group_id=16528