pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Cc: Maksim Milyutin <milyutinma@gmail.com>
Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table
Date: Tue, 2 Jan 2018 10:44:20 -0500
Message-ID: <6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com> (raw)
In-Reply-To: <20171222151023.ie4zrbgwtva7flij@alvherre.pgsql>
References: <20171222151023.ie4zrbgwtva7flij@alvherre.pgsql>

Hi Alvaro,

On 12/22/2017 10:10 AM, Alvaro Herrera wrote:
> I believe these are all fixed by the attached delta patch.
>

Thanks.

> If you have wording suggestions for the doc changes, please send them
> along.
> 

Maybe we should make the default index name more explicit under the 
'name' parameter as attached.

Best regards,
  Jesper

Attachments:

  [text/x-patch] doc-changes.patch (1.1K, ../6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com/2-doc-changes.patch)
  download | inline diff:
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 5137fe6383..7d32c5556d 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -146,7 +146,11 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
         here; the index is always created in the same schema as its parent
         table.  If the name is omitted, <productname>PostgreSQL</productname> chooses a
         suitable name based on the parent table's name and the indexed column
-        name(s).
+        name(s) using the following formular <literal>{tablename}_{columnname(s)}_{suffix}</literal>
+        where <literal>{suffix}</literal> is <literal>pkey</literal> for a primary key constraint,
+        <literal>key</literal> for a unique constraint, <literal>excl</literal> for an exclusion constraint,
+        <literal>idx</literal> or any other kind of index, <literal>fkey</literal> for a foreign key and
+        <literal>check</literal> for a check constraint.
        </para>
       </listitem>
      </varlistentry>

view thread (142+ messages)  latest in thread

Message-ID: <6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com>
Permalink:  ../6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com/
Also on:    postgresql.org/message-id/6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: jesper.pedersen@redhat.com, alvherre@alvh.no-ip.org, robertmhaas@gmail.com, david.rowley@2ndquadrant.com, simon@2ndquadrant.com, milyutinma@gmail.com
  Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table
  In-Reply-To: <6d0e39e9-58c8-3333-5ed5-7b0b45405e71@redhat.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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