psycopg2 not using appropriate type?

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: psycopg2 not using appropriate type?
Date: 2011-03-10 23:04:12
Message-ID: AANLkTim1j6mzqEQUWfNSU41m9r8ayP6HO9rb5x5SD54P@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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(at)gmail(dot)com

Responses

Browse psycopg by date

  From Date Subject
Next Message Federico Di Gregorio 2011-03-11 13:19:26 Re: psycopg2 not using appropriate type?
Previous Message Barend Köbben 2011-03-10 10:56:53 Re: psycopg used in a ASP page fails