Re: pgbench - allow backslash-continuations in custom scripts - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench - allow backslash-continuations in custom scripts
Date
Msg-id alpine.DEB.2.10.1508060640521.9678@sto
Whole thread Raw
In response to Re: pgbench - allow backslash-continuations in custom scripts  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: pgbench - allow backslash-continuations in custom scripts
List pgsql-hackers
Hello Heikki,

> I don't think we actually want backslash-continuations. The feature we want 
> is "allow SQL statements span multiple lines", and using the psql lexer 
> solves that. We don't need the backslash-continuations when we have that.

Sure. The feature *I* initially wanted was to have multi-line 
meta-commands. For this feature ISTM that continuations are, alas, the 
solution.

>> Indeed there are plenty of links already which are generated by makefiles
>> (see src/bin/pg_xlogdump/*), and probably a copy is made on windows. There
>> should no file duplication within the source tree.
>
> Yeah, following the example of pg_xlogdump and others is the way to go.
>
> Docs need updating, and there's probably some cleanup to do before this is 
> ready for committing, but overall I think this is definitely the right 
> direction.

I've created an entry for the next commitfest, and put the status to 
"waiting on author".

> I complained upthread that this makes it impossible to use "multi-statements" 
> in pgbench, as they would be split into separate statements, but looking at 
> psqlscan.l there is actually a syntax for that in psql already. You escape 
> the semicolon as \;, e.g. "SELECT 1 \; SELECT 2;", and then both queries will 
> be sent to the server as one. So even that's OK.

Good!

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Hash index creation warning
Next
From: Haribabu Kommi
Date:
Subject: Re: Priority table or Cache table