Carriage return/Line feed / space at end of line

[Frank Warmerdam]

On 11/10/05, Huub Fleuren <hfl at home.nl> wrote:
> Hi Frank,
>
> For us it is both risky and too time consuming to upgrade (recompile) on
> debian.
> (i've been stuck on this for almost a week on this allready)

Huub,

You can install FWTools 1.0.0a6 for Linux on Debian.  It is completely
self contained (won't mess anything existing up) and should include postgis
support.  You can setup a minimal .map file that you think demonstrates
the problem and it should be relatively easy for someone else to take that
and run with it.

> I suppose that it can be checked with any of your own testcases for
> POSTGRESQL

Well, possibly, but it could also lead some developer on a wild goose
chance trying to reproduce things.   I can't speak for all the other developers
but I for one prefer to push as much work as possible onto the bug reporter
unless I have a financial incentive (or the reporter has a good deal of
"contributor mojo" on account already).

> I have some more info for you though.
>
> The error was found after the truncated DATA statement in the
> mapserv.log file appeared not to execute in pgAdmin if the lines end in
> a table_name
>
> compare:
>
> "select blabla from table_name inner join table_name... " = ok
>
> "select blabla from table_name
>   inner join table_name... " = not ok
>
> Is the next line is concatenated to the name in postgres?
> (where a cr is whitespace and lf is not (once in postgres))
>
> So it may be a bug in postgres, but than mapserver is the client: maybe
> put the complete statement in one line, inserting whitespace where
> appropriate?

I'm not sure I follow all this.  But it just makes it all the more
important to provide an easy to reproduce test case.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent