pgsql: Disallow creation of indexes on system columns (except for OID). - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Disallow creation of indexes on system columns (except for OID).
Date
Msg-id E1arSpG-0008Fr-E1@gemulon.postgresql.org
Whole thread Raw
List 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(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Make fallback implementation of pg_memory_barrier() work in 9.2
Next
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Change some "user" to "role" for consistency in the section