On Thu, Jul 14, 2016 at 07:03:03AM +0200, Christoph Zwerschke wrote: > Am 14.07.2016 um 06:40 schrieb Christoph Zwerschke: > >The "int pgtype" in the parameter list should actually be "Oid pgtype". > > Oh, and also the "(Oi)" argument passed to PyObject_CallFunction() should be > changed to "(OI)". You need to make both of these changes.
Confirmed that with both those changes the query succeeds: < 2016-07-15 21:39:20.724 EDT telsasoft >ERROR: syntax error at or near "-" < 2016-07-15 21:39:20.724 EDT telsasoft >CONTEXT: invalid type name "-799870613" < 2016-07-15 21:39:20.724 EDT telsasoft >STATEMENT: SELECT oid, typname, typname::regtype, typtype, typcategory, typdelim, typrelid FROM pg_type WHERE oid=$1::regtype vs < 2016-07-15 21:39:19.971 EDT pryzbyj >LOG: execute <unnamed>: SELECT oid, typname, typname::regtype, typtype, typcategory, typdelim, typrelid FROM pg_type WHERE oid=$1::regtype < 2016-07-15 21:39:19.971 EDT pryzbyj >DETAIL: parameters: $1 = 'geometry' Justin _______________________________________________ PyGreSQL mailing list [email protected] https://mail.vex.net/mailman/listinfo.cgi/pygresql
