Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000719 ] string representation for large objects ist wrong

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000719 ] string representation for large objects ist wrong
Date: 2006-08-29 13:17:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Bugs item #1000719, was opened at 2006-08-29 15:17
You can respond by visiting:

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Thomas Zehbe (thomasz)
Assigned to: Nobody (None)
Summary: string representation for large objects ist wrong

Initial Comment:
Trying the db sample of wxWidgets 2.7.0-1 the postgreSQL server logged this message:
LINE_CNT,LANGUAGE,PICSIZE,PICTURE) VALUES ('t','','','','','','','1980-01-01 00:00:00'::timestamp,0,0,0,0,28151,'11
FEHLER:  Typ »lo« existiert nicht

The isnert statement tries to insert a blob and the string represanttion ind psqlodbc driver is actually "lo", wich isn't accepted.

After changing the represantion in 2 files to "oid" blob support works.
I changed the following files:
changed #define PG_TYPE_LO_NAME			"lo"
to #define PG_TYPE_LO_NAME			"oid"

convert.c in the ResolveOneParam() function at line 2983
from 	sprintf(param_string, "'%d'::lo", lobj_oid);
to	sprintf(param_string, "'%d'::oid", lobj_oid);

My versions are psqlodbc 8.01.0200 and PostgreSQL 8.0.1

Hope this helps.



You can respond by visiting:

pgsql-odbc by date

Next:From: Dave PageDate: 2006-08-29 13:25:57
Subject: Re: [COMMITTERS] psqlodbc - psqlodbc: Fixed dllname of win32 ANSI: psqlodbca Unicode:
Previous:From: Mark Morgan LloydDate: 2006-08-29 13:12:32
Subject: Re: Latest ODBC driver?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group