Re: \gexec \watch - Mailing list pgsql-hackers

From David Fetter
Subject Re: \gexec \watch
Date
Msg-id 20181206151448.GF16928@fetter.org
Whole thread Raw
In response to Re: \gexec \watch  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Thu, Dec 06, 2018 at 05:01:26AM -0300, Alvaro Herrera wrote:
> On 2018-Dec-06, David Fetter wrote:
> 
> > There's a bit of a philosophical issue here, or a mathematical one,
> > whichever way you want to put it.  Does it actually make sense to have
> > the behavior of one "semicolon" spill onto another?
> 
> Honestly, I don't see the mathematicality in this.  It either works, or
> it doesn't -- and from my POV right now it doesn't.  Are you saying we
> need a \gexecwatch for this to work?

We could call it something a little shorter, but yes. The part you
trimmed away had descriptions of why the current behavior is correct.
We don't really have ways to compose \ operators. If we're going to
add composition to the psql language, we should think it through
carefully, not just glom it on for a single special case.

> I can of course solve my problem with a simple python program, but psql
> is so close ...

Agreed!

Best,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: zheap: a new storage format for PostgreSQL
Next
From: Pavel Stehule
Date:
Subject: Re: zheap: a new storage format for PostgreSQL