pgsql: Disallow creation of indexes on system columns (except for OID).

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Disallow creation of indexes on system columns (except for OID).
Date: 2016-04-16 16:12:02
Message-ID: E1arSpG-0008Fr-E1@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Disallow creation of indexes on system columns (except for OID).

Although OID acts pretty much like user data, the other system columns do
not, so an index on one would likely misbehave. And it's pretty hard to
see a use-case for one, anyway. Let's just forbid the case rather than
worry about whether it should be supported.

David Rowley

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c34df8a003c3e478d70e8251bd2a24d710b297d4

Modified Files
--------------
src/backend/commands/indexcmds.c | 37 ++++++++++++++++++++++++++++++
src/test/regress/expected/create_index.out | 16 +++++++++++++
src/test/regress/sql/create_index.sql | 19 +++++++++++++++
3 files changed, 72 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2016-04-16 16:56:35 pgsql: doc: Change some "user" to "role" for consistency in the section
Previous Message Tom Lane 2016-04-16 14:42:37 pgsql: Make fallback implementation of pg_memory_barrier() work in 9.2