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

From Michael Fuhr
Subject Re: Basic problems using plpythonu - bug?
Date
Msg-id 20060217175732.GA45419@winnie.fuhr.org
Whole thread Raw
In response to Basic problems using plpythonu - bug?  ("Curt Schwaderer" <curt.schwaderer@mchsi.com>)
List pgsql-general
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: Teodor Sigaev
Date:
Subject: Re: TSearch2 / German compound words / UTF-8
Next
From: Ragnar
Date:
Subject: Re: A question about Vacuum analyze