Re: Basic problems using plpythonu - bug? - Mailing list pgsql-general

From Curt Schwaderer
Subject Re: Basic problems using plpythonu - bug?
Date
Msg-id 008a01c633f7$f7eab290$67fea8c0@curtf5ff5b67a9
Whole thread Raw
In response to Basic problems using plpythonu - bug?  ("Curt Schwaderer" <curt.schwaderer@mchsi.com>)
List pgsql-general
Thanks a bunch - that cleaned everything up!

Curt

----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Curt Schwaderer" <curt.schwaderer@mchsi.com>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, February 17, 2006 11:57 AM
Subject: Re: [GENERAL] Basic problems using plpythonu - bug?


> On Fri, Feb 17, 2006 at 11:38:21AM -0600, Curt Schwaderer wrote:
>> ERROR: plppython: function "send_ctl_msg" failed
>> DETAIL: exceptions.KeyError: 'cfgCmd'
>
> You're getting bit by case folding of identifiers.  You created
> the column as:
>
>>   cfgCmd            VARCHAR(16),  -- ENS configuration control command
>
> Since you didn't quote the identifier it's folded to lowercase, so
> when you refer to it as
>
>>   ens_cmd = rv[0]["cfgCmd"]
>
> you get a KeyError exception.  Try using rv[0]["cfgcmd"].  You might
> want to read the documentation about quoted identifiers:
>
> http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
>
> --
> Michael Fuhr


pgsql-general by date:

Previous
From: "Darryl W. DeLao Jr."
Date:
Subject: Performance Tuning
Next
From: "mmaclennan"
Date:
Subject: connecting to pgsql