Re: Stripping white-space in SELECT statments - Mailing list pgsql-sql

From Andreas Joseph Krogh
Subject Re: Stripping white-space in SELECT statments
Date
Msg-id 200209191942.54258.andreak@officenet.no
Whole thread Raw
In response to Re: Stripping white-space in SELECT statments  (Thorbjörn Eriksson <thorbjorn.eriksson@ec.se>)
List pgsql-sql
On Thursday 19 September 2002 13:41, Thorbjörn Eriksson wrote:
> By "our system" I mean the software that uses the database. It is a quit
> old software written in C that has been ported a couple of times to
> different *NIX platforms using different DBMS's. It uses in-house developed
> functions that, depending on parameters, creates a variety of SQL
> statements that in the end gets executed by PQexec (from libpq i guess).
[snip]
> > > artnrgrpmtrln_1<='201901  ÿ'

This looks like to me that your C software doesn't '\0' terminate its strings
proparly and some random byte gets in the query.

--
Andreas Joseph Krogh <andreak@officenet.no>



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How To Get Bytea Data Instead Of Its Oid
Next
From: "Michael Paesold"
Date:
Subject: Re: Table Copy.