Thread: Re: pltcl regress test?

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

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 #