| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Fabrízio Mello <fabriziomello(at)gmail(dot)com> |
| Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>, José Luis Tallón <jltallon(at)adv-solutions(dot)net> |
| Subject: | Re: CREATE IF NOT EXISTS INDEX |
| Date: | 2014-10-06 02:12:05 |
| Message-ID: | CABRT9RDy-d84A6kgJzDcJHdaTSjCTSN7FFNFLhXafME52UiiUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Oct 6, 2014 at 4:17 AM, Fabrízio de Royes Mello
<fabriziomello(at)gmail(dot)com> wrote:
> On Sun, Oct 5, 2014 at 9:52 AM, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
>> CREATE INDEX ... [ IF NOT EXISTS name | name ] ON ...
>>
>> Maybe I'm just slow, but it took me a few minutes to understand what
>> this means. :)
>
> Well, I try to show that "IF NOT EXISTS" require the "name". Is this wrong?
No, I'm sorry, you misunderstood me. It was totally correct before, it
just wasn't easy to understand at first.
> CREATE INDEX ... [ IF NOT EXISTS [ name ] ] ON ...
I think this one is wrong now. It suggests these are valid syntaxes:
CREATE INDEX ... ON ...
CREATE INDEX ... IF NOT EXISTS ON ... <-- wrong
CREATE INDEX ... IF NOT EXISTS name ON ...
Regards,
Marti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-10-06 02:13:53 | Re: Feasibility of supporting bind params for all command types |
| Previous Message | Michael Paquier | 2014-10-06 01:42:50 | Re: WAL format and API changes (9.5) |