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
>
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 |