Error in PlPython procedure - Mailing list pgsql-general

From mars_osrp
Subject Error in PlPython procedure
Date
Msg-id 15601869.post@talk.nabble.com
Whole thread Raw
Responses Re: Error in PlPython procedure
Re: Error in PlPython procedure
List pgsql-general
Hi All,

I am using PlPython procedure to insert data in a table:

plan = plpy.execute("insert into test(id,name) values(1 , 'test_py')")

I am getting error:
ERROR:  invalid input syntax for integer: "<PLyResult object at 0x374a5a70>"

In fact preparing a plan and passing a list of values for columns is also
giving same error.

What is correct valid input syntax for integer in PlPython?

Mars_osrp
--
View this message in context: http://www.nabble.com/Error-in-PlPython-procedure-tp15601869p15601869.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: SunWuKung
Date:
Subject: Re: Vacuous errors in pg_dump ... | pg_restore pipeline
Next
From: Stephen Davies
Date:
Subject: ts_headline