pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtype cast
3+ messages / 3 participants
[nested] [flat]
* type cast
@ 2010-08-10 16:38 Imre Horvath <blemidon@gmail.com>
2010-08-10 16:48 ` Re: type cast Peter Eisentraut <peter_e@gmx.net>
2010-08-10 17:42 ` Re: type cast Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Imre Horvath @ 2010-08-10 16:38 UTC (permalink / raw)
To: pgsql-sql
Hi!
I don't know if it's the right place or the psycopg2 list:
I've got a plpython function, with a character varying param.
I can call it from sql.
But when i try to call it with psycopg2.callproc('testfunc', ['test']),
i've got the error:
function testfunc(unknown) does not exist
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Thanks in advance:
Imre Horvath
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: type cast
2010-08-10 16:38 type cast Imre Horvath <blemidon@gmail.com>
@ 2010-08-10 16:48 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2010-08-10 16:48 UTC (permalink / raw)
To: Imre Horvath <blemidon@gmail.com>; +Cc: pgsql-sql
On tis, 2010-08-10 at 18:38 +0200, Imre Horvath wrote:
> Hi!
>
> I don't know if it's the right place or the psycopg2 list:
>
> I've got a plpython function, with a character varying param.
> I can call it from sql.
> But when i try to call it with psycopg2.callproc('testfunc', ['test']),
> i've got the error:
> function testfunc(unknown) does not exist
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
psycopg list. But you should add version information about psycopg and
PostgreSQL.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: type cast
2010-08-10 16:38 type cast Imre Horvath <blemidon@gmail.com>
@ 2010-08-10 17:42 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2010-08-10 17:42 UTC (permalink / raw)
To: Imre Horvath <blemidon@gmail.com>; +Cc: pgsql-sql
Imre Horvath <blemidon@gmail.com> writes:
> I've got a plpython function, with a character varying param.
> I can call it from sql.
> But when i try to call it with psycopg2.callproc('testfunc', ['test']),
> i've got the error:
> function testfunc(unknown) does not exist
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
That doesn't sound like a type cast issue. I'd bet you connected to the
wrong database from your python app, or are using a different
search_path setting, or something along that line.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-08-10 17:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-10 16:38 type cast Imre Horvath <blemidon@gmail.com>
2010-08-10 16:48 ` Peter Eisentraut <peter_e@gmx.net>
2010-08-10 17:42 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox