JanWieck@t-online.de (Jan Wieck) writes:
> [ pltcl's regress test is failing ]
>     Seems  to suffer due to some bug. The functions use a feature
>     of the Tcl interpreter, who treates a backslash followed by a
>     newline  as  a  whitespace  that  doesn't start a new command
>     (previous command is continued).

>     I did some other tests and ISTM that it is totally impossible
>     by  now to insert data where backslash is followed by newline
>     at all. At least I wasn't able to quote  it  properly.  Maybe
>     these are filtered already by psql?

Yes, it seems that psql's handling of backslashes has changed for the
worse.

In current sources, I type:

regression=# select 'abc  \\
regression'# def';
 ?column?
-----------
 abc
def
(1 row)

Running with -d2, the postmaster log shows:

DEBUG:  StartTransactionCommand
DEBUG:  query: select 'abc  
def';
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand

psql has eaten the backslashes, even though they are within quotes.
This is not cool.  6.5.* psql did not do that, and current sources
don't either *unless* the backslashes are at the very end of a line.

			regards, tom lane

Mon, 17 Jul 2000 10:36:54 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: pltcl regress test? 
Tom Lane wrote:
> JanWieck@t-online.de (Jan Wieck) writes:
> > [ pltcl's regress test is failing ]
> >     Seems  to suffer due to some bug. The functions use a feature
> >     of the Tcl interpreter, who treates a backslash followed by a
> >     newline  as  a  whitespace  that  doesn't start a new command
> >     (previous command is continued).
>
> >     I did some other tests and ISTM that it is totally impossible
> >     by  now to insert data where backslash is followed by newline
> >     at all. At least I wasn't able to quote  it  properly.  Maybe
> >     these are filtered already by psql?
>
> Yes, it seems that psql's handling of backslashes has changed for the
> worse.

    After  Peter's  fix to psql I updated the pltcl test expected
    result and removed an ordering problem from the test queries.
    Should work again now.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



Tue, 18 Jul 2000 13:27:15 +0200 (MEST)
JanWieck@t-online.de (Jan Wieck)
Re: pltcl regress test?