Re: Basic problems using plpythonu - bug?
От | Curt Schwaderer |
---|---|
Тема | Re: Basic problems using plpythonu - bug? |
Дата | |
Msg-id | 008a01c633f7$f7eab290$67fea8c0@curtf5ff5b67a9 обсуждение исходный текст |
Ответ на | Basic problems using plpythonu - bug? ("Curt Schwaderer" <curt.schwaderer@mchsi.com>) |
Список | 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 по дате отправления: