Re: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS
Date
Msg-id 20170621020210.eqf44aoqjcu3qtma@alvherre.pgsql
Whole thread Raw
In response to [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-bugs
Bruno Wolff III wrote:
> I'm not seeing an obvious error in my attempt to use CREATE STATISTICS IF
> NOT EXISTS. Given this is new, maybe there is a bug in the parser.

You're absolutely right, and this is a bug in the parser -- I probably
misplaced the IF NOT EXISTS clause while playing with Tomas' parser
changes.  Here's the fix.  I'm a bit troubled that this change doesn't
seem to affect any tests, so I'll add some before pushing.

(Now, "statistics" being plural would seem to call for CREATE STATISTICS
IF NOT EXIST, rather than EXISTS, but I'll put that thought aside on
account of it being just too weird ...)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS
Next
From: Amit Langote
Date:
Subject: Re: [BUGS] Beta 10 parser error for CREATE STATISTICS IF NOT EXISTS