[Pypgsql-users] Trying to understand an error message

[larry price <laprice@gm...>]

I'm using a dictionary interpolated string to create a query statement.
When I generate the query by hand sql =3D query % params
and execute the sql from inside psql, it works.

when i create cursor and use cursor.execute(query,params)
i get the following traceback

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/tmp/python-5481BIu.py", line 134, in insert_title
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3048,
in execute
    self.res =3D self.conn.conn.query(_qstr % parms)
TypeError: float argument required

line 3048 seems to be where the Exception is handled, but the
'self.res =3D ...' line occurs in method callproc, and I don't see where
it gets called from inside the method execute.

the only oddball column is one that is of type numeric(9,2)
do I need to wrap this in PgNumeric before I hand the dictionary to execute
Or is there something deepr going on?


--=20
http://Zoneverte.org -- information explained
Do you know what your IT infrastructure does?

Re: [Pypgsql-users] Data type for oid

[Billy G. Allie <bill.allie@de...>]

On Tue, 2005-08-30 at 16:44 +0000, Rod MacNeil wrote: 

> Hi All,
> 
> I'm using pyPgSQL 2.4 postgres 7.4.7 on fedora core 3.
> 
> I have a question about the data type returned in cursor.description when oid is included in the select.
> 
> When I run a query like "select oid, field1,field2 from mytable where field2='x'".
> 
> cursor.description says the oid column is type 'rowid' if there are result rows, but if there are no result rows it says the type is 'blob'.
> 
> Is this a bug?
> 
> Rod MacNeil

Not really.  It's caused by the fact that an OID can represent a rowid
or a postgresql large object (i.e. blob).  The only way to tell which
one it is is to see if the value of the OID exists as a large object or
not.  Since there is no result (and hence not value) the lookup can't be
made so a type of blob is assumed.
--
____       | Billy G. Allie    | Domain....: Bill.Allie@...
|  /|      | 7436 Hartwell     | MSN.......: B_G_Allie@...
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |

[Pypgsql-users] Data type for oid

[Rod MacNeil <rmacneil@in...>]

Hi All,

I'm using pyPgSQL 2.4 postgres 7.4.7 on fedora core 3.

I have a question about the data type returned in cursor.description =
when oid is included in the select.

When I run a query like "select oid, field1,field2 from mytable where =
field2=3D'x'".

cursor.description says the oid column is type 'rowid' if there are =
result rows, but if there are no result rows it says the type is 'blob'.

Is this a bug?

Rod MacNeil


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D NOTE:
This e-mail message is intended only for the named recipient(s) above
and may contain information that is privileged, confidential and/or
exempt from disclosure under applicable law. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this e-mail message.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

[Pypgsql-users] dictionary as function parameter?

[<gherzig@fm...>]

Hi all. I want to send some dictionary as an argument for my plpythonu
function. Let's say

CREATE OR DECLARE FUNCTION test(__dictionary__)

but cant figure out if it is possible or not.

Is it?

Thanks a lot.


--=20
Gerardo Herzig
Direccion General de Organizacion y Sistemas
Facultad de Medicina
U.B.A.