Re: SQLGetInfo Bug - Mailing list pgsql-odbc

From Dave Page
Subject Re: SQLGetInfo Bug
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B88547@mail.vale-housing.co.uk
Whole thread Raw
In response to SQLGetInfo Bug  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: SQLGetInfo Bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 02 January 2003 14:36
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org; Didier Moens
> Subject: Re: [ODBC] SQLGetInfo Bug
>
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
> > snprintf(tmp, sizeof(tmp) - 1, "%s %s", POSTGRESDRIVERVERSION,
> > conn->pg_version);
>
> > but somewhere along the way garbage is getting appended back on the
> > string returned:
>
> > [328][SQLGetInfo][328]PGAPI_GetInfo: entering...fInfoType=18
> > [328]PGAPI_GetInfo: p='07.02.0005 PostgreSQL 7.3 on
> > i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC)
> > 3.2.1 20021207 (Red Hat Linux 8wãF¸8Ù', len=0, value=0, cbMax=0
>
> > I can't see what the heck I've done wrong here. Any ideas?
>
> I think the error is elsewhere, and that the garbage is
> already present in conn->pg_version.

Hi Tom,

The garbage is not there if I use sprintf with a larger size of tmp. I've tried variations of the code to check
(withoutluck) but I assume I'm not somehow knocking the null off the end of the string? 

Also of note, is that the logging call from which I'm seeing the garbage occurs before any other manipulation of the
string.

Regards, Dave.

pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQLGetInfo Bug
Next
From: Tom Lane
Date:
Subject: Re: SQLGetInfo Bug