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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Disallow creation of indexes on system columns (except for OID).
Дата
Msg-id E1arSpG-0008Fr-E1@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Make fallback implementation of pg_memory_barrier() work in 9.2
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: doc: Change some "user" to "role" for consistency in the section