]> granicus.if.org Git - postgresql/commit
Disallow creation of indexes on system columns (except for OID).
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 16 Apr 2016 16:11:41 +0000 (12:11 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 16 Apr 2016 16:11:41 +0000 (12:11 -0400)
commitc34df8a003c3e478d70e8251bd2a24d710b297d4
tree7ce8d65cc1998a5b3334a7a6a83d1caab4205b0d
parent99f2f3c19ae7d6aa2950a9bdb549217c5a60d941
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
src/backend/commands/indexcmds.c
src/test/regress/expected/create_index.out
src/test/regress/sql/create_index.sql