Thread: psycopg2 not using appropriate type?

psycopg2 not using appropriate type?

From
Wells Oliver
Date:
It seems when I use callproc(), psycopg2 isn't properly casting strings as text or character varying.

For example:

values = [pid, 4, 4, 'bureau pitcher ama', 0, 130, row['report_dte'], row['report_dte'], 1, 1, 1, None, None, 'published', row['report_dte']]
cur.callproc('header', values)

Yields:

psycopg2.ProgrammingError: function basetek_scouting.insert_report_header(integer, integer, integer, unknown, integer, integer, unknown, unknown, integer, integer, integer, unknown, unknown, unknown, unknown) does not exist
LINE 1: SELECT * FROM header(509952,4.

First, the "bureau pitcher ama" is unknown instead of text/character, and row["report_dte"] are all unknown, where they are date types in the database, and datetime.date objects in python.

Any idea? Using python 2.6.5.

--
Wells Oliver
wellsoliver@gmail.com

Re: psycopg2 not using appropriate type?

From
Federico Di Gregorio
Date:
On 11/03/11 00:04, Wells Oliver wrote:
> It seems when I use callproc(), psycopg2 isn't properly casting strings
> as text or character varying.
>
> For example:
>
> values = [pid, 4, 4, 'bureau pitcher ama', 0, 130, row['report_dte'],
> row['report_dte'], 1, 1, 1, None, None, 'published', row['report_dte']]
> cur.callproc('header', values)
>
> Yields:
>
> psycopg2.ProgrammingError: function
> basetek_scouting.insert_report_header(integer, integer, integer,
> unknown, integer, integer, unknown, unknown, integer, integer, integer,
> unknown, unknown, unknown, unknown) does not exist
> LINE 1: SELECT * FROM header(509952,4.
>
> First, the "bureau pitcher ama" is unknown instead of text/character,
> and row["report_dte"] are all unknown, where they are date types in the
> database, and datetime.date objects in python.
>
> Any idea? Using python 2.6.5.

Can you show us the function signature?

--
Federico Di Gregorio                         federico.digregorio@dndg.it
Studio Associato Di Nunzio e Di Gregorio                  http://dndg.it
           Purtroppo i creazionisti non si sono ancora estinti. -- vodka