Enterprise Postgres 17 リリース情報

2.2.66 psqlの\df+コマンドの表示の変更

非互換

psqlの\df+コマンドで"ソースコード"ではなく"内部名"を表示します。

Fujitsu Enterprise Postgres 15以前の場合

postgres=*# \df+ psql_df_*
                                                                                           List of functions
 Schema |       Name       | Result data type | Argument data types | Type | Volatility | Parallel |       Owner       | Security | Ac
cess privileges | Language |     Source code      | Description
--------+------------------+------------------+---------------------+------+------------+----------+-------------------+----------+---
----------------+----------+----------------------+--------------
 public | psql_df_internal | double precision | double precision    | func | immutable  | safe     | regress_psql_user | invoker  |
                | internal | dsin                 |
 public | psql_df_plpgsql  | void             |                     | func | volatile   | unsafe   | regress_psql_user | invoker  |
                | plpgsql  |  begin return; end;  | some comment
 public | psql_df_sql      | integer          | x integer           | func | volatile   | unsafe   | regress_psql_user | definer  |
                | sql      | BEGIN ATOMIC        +|
        |                  |                  |                     |      |            |          |                   |          |
                |          |  SELECT (x + 1);    +|
        |                  |                  |                     |      |            |          |                   |          |
                |          | END                  |
(3 rows)

Fujitsu Enterprise Postgres 16の場合

postgres=*# \df+ psql_df_*
                                                                                       List of functions
 Schema |       Name       | Result data type | Argument data types | Type | Volatility | Parallel |       Owner       | Security | Ac
cess privileges | Language | Internal name | Description
--------+------------------+------------------+---------------------+------+------------+----------+-------------------+----------+---
----------------+----------+---------------+--------------
 public | psql_df_internal | double precision | double precision    | func | immutable  | safe     | regress_psql_user | invoker  |
                | internal | dsin          |
 public | psql_df_plpgsql  | void             |                     | func | volatile   | unsafe   | regress_psql_user | invoker  |
                | plpgsql  |               | some comment
 public | psql_df_sql      | integer          | x integer           | func | volatile   | unsafe   | regress_psql_user | definer  |
                | sql      |               |
(3 rows)

対処方法

ありません。