Quick Links

Re: CREATE IF NOT EXISTS INDEX

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	fabriziomello(at)gmail(dot)com
Cc:	Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: CREATE IF NOT EXISTS INDEX
Date:	2014-09-30 21:43:03
Message-ID:	21784.1412113383@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= <fabriziomello(at)gmail(dot)com> writes:
> What's your thoughts about we implement IF NOT EXISTS for CREATE INDEX?

It's got the same semantic problems as every other variant of CINE.

If there were a huge groundswell of demand for it, maybe we'd hold our
noses and do it anyway. But I'm against doing it without that.

regards, tom lane

In response to

CREATE IF NOT EXISTS INDEX at 2014-09-30 21:20:01 from Fabrízio de Royes Mello

Responses

Re: CREATE IF NOT EXISTS INDEX at 2014-09-30 21:49:21 from Kirk Roybal
Re: CREATE IF NOT EXISTS INDEX at 2014-09-30 22:01:35 from Josh Berkus

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Josh Berkus	2014-09-30 21:44:07	Re: INSERT ... ON CONFLICT {UPDATE \| IGNORE}
Previous Message	Kevin Grittner	2014-09-30 21:39:45	Re: INSERT ... ON CONFLICT {UPDATE \| IGNORE}