pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-sql@postgresql.org
Subject: Indexes and inheritance (and access rights)
Date: Thu, 09 Jul 1998 12:47:08 -0400
Message-ID: <2426.900002828@sss.pgh.pa.us> (raw)

If I have a collection of tables related by inheritance, is there
any (forced or optional) relationship between indexes on those tables?

For example, if I have a table A with an index Ai, and I create
table B that INHERITS (A), do I automatically get an index Bi on
B with the same properties as Ai?  (For that matter, if it's *not*
automatic, can I make it happen somehow?  I'd like the index structure
of a table to be part of its class definition, in essence.)

Is there a way to make a single index that indexes records in both
A and B?  (For example, to enforce uniqueness of a particular field
globally across A and all its inheritors.)


While I'm on about indexes: it seems I can GRANT or REVOKE access
rights on an index, but what the heck does that mean?  Are access
rights on an index actually checked when doing operations on the
underlying table?  It would seem rather confusing to do that.

			regards, tom lane



Message-ID: <2426.900002828@sss.pgh.pa.us>
Permalink:  ../2426.900002828@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2426.900002828@sss.pgh.pa.us

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us
  Subject: Re: Indexes and inheritance (and access rights)
  In-Reply-To: <2426.900002828@sss.pgh.pa.us>
  References: <2426.900002828@sss.pgh.pa.us>

* 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