pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed"DROP INDEX" correction
2+ messages / 2 participants
[nested] [flat]
* "DROP INDEX" correction
@ 2019-10-02 07:55 Oto Brglez <otobrglez@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Oto Brglez @ 2019-10-02 07:55 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
Hello people!
I'm new to this place and this is obviously my first message to you guys.
I've been using PostgreSQL for years now, deeply like it and I came to a
point when I wish to give some of this love back. :)
So; I'm reaching out this mailing list - hopefully the right one - because
we found a small "bug" or should I rather say missing information in the
documentation.
Inside the documentation for DROP INDEX (
https://www.postgresql.org/docs/9.6/sql-dropindex.html) - pointing to 9.6
version - there is no information that if you use DROP INDEX with
CONCURRENTLY that you can't drop several indices at once. Meaning that this
does not work:
DROP INDEX CONCURRENTLY IF EXISTS my_index_one, my_index_two;
PostgreSQL itself will raise exception
PG::FeatureNotSupported: ERROR: DROP INDEX CONCURRENTLY does not support
dropping multiple objects
Although this is the correct statement per synopsis.
DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT
]
Proposal.
I suggest that you add a statement/explanation under Parameters
> CONCURRENTLY that would say something like
"DROP INDEX with CONCURRENTLY can only accept one index."
I hope that this message will be helpful to someone and I wish you a
pleasant day!
P.s.: If I can make this recommendation in the form of a patch or something
please point me in the right direction.
Regards,
- Oto Brglez
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: "DROP INDEX" correction
@ 2019-10-03 01:41 Michael Paquier <michael@paquier.xyz>
parent: Oto Brglez <otobrglez@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Paquier @ 2019-10-03 01:41 UTC (permalink / raw)
To: Oto Brglez <otobrglez@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
Hi Oto,
On Wed, Oct 02, 2019 at 09:55:14AM +0200, Oto Brglez wrote:
> I suggest that you add a statement/explanation under Parameters
> > CONCURRENTLY that would say something like
>
> "DROP INDEX with CONCURRENTLY can only accept one index."
>
> I hope that this message will be helpful to someone and I wish you a
> pleasant day!
The documentation of DROP INDEX includes already the following
sentence in the paragraph for CONCURRENTLY:
https://www.postgresql.org/docs/devel/sql-dropindex.html
"Only one index name can be specified"
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-10-03 01:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-10-02 07:55 "DROP INDEX" correction Oto Brglez <otobrglez@gmail.com>
2019-10-03 01:41 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox