Re: InternalError Exception

Joachim Worringen <[email protected]> Fri, 28 May 2010 15:24:29 +0200
Newsgroups gmane.comp.python.db.psycopg.devel
Organization IAT GmbH
Message-ID <[email protected]>
On 05/28/2010 03:19 PM, Joachim Worringen wrote:
> On 05/28/2010 02:46 PM, Joachim Worringen wrote:
>> On 05/28/2010 02:29 PM, Massa, Harald Armin wrote:
>>> Joachim,
>>>
>>> you can ask PostgreSQL about the columns in a table:
>> [..]
>>
>> Thanks, Harald - but in this case, this is a more complex workaround
>> than just catching InternalError in addtion to ProgrammingError.
>>
>> I feel that InternalError should not be raised in the first place at
>> this point (and normally, it isn't).
>
> Think I found the reason: I need to close() (or somehow reset?) the
> cursor before proceeding after a ProgrammingError exception.

Correction: commit the transaction is the relevant operation.

  Joachim