Re: plpython integer types

From: Emiliano Amilcarelli <amiemi(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: plpython integer types
Date: 2005-11-17 14:46:46
Message-ID: 437C97D6.8070801@tin.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

No, it doesn,'t work if i use int4
I solved the problem casting the type:

plan=plpy.prepare("INSERT INTO
\"tmp_test\"(\"AGENT\",\"ERRORE\",\"PROVE_FALLITE\",\"DATA_ORA_ACCESSO\")
values($1,$2,$3::int,$4)",["text","text","text","text"])

Thanks for help....

Regards.

Emil

Tom Lane ha scritto:
> Emiliano Amilcarelli <amiemi(at)tin(dot)it> writes:
>
>> a plpython function i'm writing fail with a strange ( to me ) message error:
>>
>
>
>> .....
>> plan=ply.prepare("intert into text,text1,integer1,text"
>> values($1,$2,$3,$4)",["text","text","integer","text"])
>> ply.execute(plan,[var1,var2,var3,var4])
>> .....
>>
>
>
>> The backend raise an errore saying:
>> ERROR: type integer does not exist...
>>
>
> Does it work if you say "int4" instead?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message George Weaver 2005-11-17 16:55:53 Re: Problem getting xml2 contrib module working with 8.1
Previous Message Tom Lane 2005-11-17 14:21:58 Re: plpython integer types