Re: proposal - assign result of query to psql variable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: proposal - assign result of query to psql variable
Date
Msg-id 3668.1350249220@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal - assign result of query to psql variable  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal - assign result of query to psql variable  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: proposal - assign result of query to psql variable  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> [ gset_08.diff ]

In the course of adding a new backslash command, this patch manages to
touch:

* the main loop's concept of what types of backslash commands exist (PSQL_CMD_NOSEND ... what's the point of that,
ratherthan making this work the same as \g?)
 
* SendQuery's concept of how to process command results (again, why isn't this more like \g?)
* ExecQueryUsingCursor's concept of how to process command results (why? surely we don't need \gset to use a cursor)
* the psql lexer (adding a whole bunch of stuff that probably doesn't belong there)
* the core psql settings construct (to store something that is in no way a persistent setting)

Surely there is a less ugly and invasive way to do this.  The fact
that the reviewer keeps finding bizarre bugs like "another backslash
command on the same line doesn't work" seems to me to be a good
indication that this is touching things it shouldn't.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: Re: [PATCH] Make pg_basebackup configure and start standby [Review]
Next
From: Brar Piening
Date:
Subject: Re: Visual Studio 2012 RC