Обсуждение: Reference tables in triggers are supported in 10

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/infoschema-triggers.html
Description:

The documentation states the following:
action_reference_old_table    sql_identifier    Applies to a feature not available
in PostgreSQL
action_reference_new_table    sql_identifier    Applies to a feature not available
in PostgreSQL
action_reference_old_row    sql_identifier    Applies to a feature not available
in PostgreSQL
action_reference_new_row    sql_identifier    Applies to a feature not available
in PostgreSQL

...but REFERENCING OLD/NEW TABLE AS is valid in postgres 10.  Why does the
infoschema not store this information.  I believe this is causing issues in
3rd party tools (DataGrip specifically) that probably rely on
information_schema to generate triggers and omit this key information. I
dont think this is a documention bug as much as a bug in postgres not
storing the information in information_schema.

On 2019-09-06 16:47, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/10/infoschema-triggers.html
> Description:
> 
> The documentation states the following:
> action_reference_old_table    sql_identifier    Applies to a feature not available
> in PostgreSQL
> action_reference_new_table    sql_identifier    Applies to a feature not available
> in PostgreSQL
> action_reference_old_row    sql_identifier    Applies to a feature not available
> in PostgreSQL
> action_reference_new_row    sql_identifier    Applies to a feature not available
> in PostgreSQL
> 
> ...but REFERENCING OLD/NEW TABLE AS is valid in postgres 10.  Why does the
> infoschema not store this information.

The information schema changes are in PostgreSQL 11.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services