Bug in information_schema: column names don't match spec

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Bug in information_schema: column names don't match spec
Дата
Msg-id 23538.1286551180@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Bug in information_schema: column names don't match spec  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
While reading the proposed triggers-on-views patch I noticed that
information_schema.sql defines these columns in the TRIGGERS view:
          CAST(            CASE WHEN t.tgtype & 2 = 2 THEN 'BEFORE' WHEN t.tgtype & 64 = 64 THEN 'INSTEAD OF' ELSE
'AFTER'END            AS character_data) AS condition_timing,          CAST(null AS sql_identifier) AS
condition_reference_old_table,         CAST(null AS sql_identifier) AS condition_reference_new_table,
CAST(nullAS sql_identifier) AS condition_reference_old_row,          CAST(null AS sql_identifier) AS
condition_reference_new_row,

In SQL:2008 I see the corresponding columns named as 
ACTION_TIMING, ACTION_REFERENCE_OLD_TABLE,ACTION_REFERENCE_NEW_TABLE,
ACTION_REFERENCE_OLD_ROW,ACTION_REFERENCE_NEW_ROW,

Was this just a thinko in our transcription, or did they rename the view
columns somewhere along the line?

Perhaps more to the point, what shall we do about it?  Just renaming the
view columns is easy enough, but should we try to do something to limit
the impact on existing clients?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Markus Wanner
Дата:
Сообщение: Re: Issues with Quorum Commit
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP: Triggers on VIEWs