Need Assistance: Command to display procedures does not work

Поиск
Список
Период
Сортировка
От Sasmit Utkarsh
Тема Need Assistance: Command to display procedures does not work
Дата
Msg-id CAM-5MT3+Gk11krD5cYQv42usQ43aD_p3ZC==a9ZKxH5SQ_N+8A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need Assistance: Command to display procedures does not work
Re: Need Assistance: Command to display procedures does not work
Список pgsql-general
Hi Postgresql Team,

Getting error while executing the below \df command to list the procedures/functions. whereas query gives the appropriate results Please assist on how to troubleshoot this.

[sutkarsh-a@dxctravel.svcs.entsvcs.com@zuccmshcd2 data-exports]$ psql "host=10.166.18.116 port=5432 dbname=shc_data user=shc_admin password=abc123 sslmode=require"
psql (10.23, server 14.9)
WARNING: psql major version 10, server major version 14.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

shc_data=> \df
ERROR:  column p.proisagg does not exist
LINE 6:   WHEN p.proisagg THEN 'agg'
               ^
HINT:  Perhaps you meant to reference the column "p.prolang".

shc_data=> SELECT proname AS function_name,proacl AS privileges FROM pg_proc WHERE proname in ('sql_insert_data_procedure','sql_select_data_procedure','sql_select_size_procedure','sql_update_data_procedure');
       function_name       | privileges
---------------------------+------------
 sql_select_size_procedure |
 sql_select_data_procedure |
 sql_insert_data_procedure |
 sql_update_data_procedure |
(4 rows)


Regards,
Sasmit Utkarsh
+91-7674022625

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

Предыдущее
От: Shanti-Dominique
Дата:
Сообщение: Re: Efficient rows filter for array inclusion with gin index
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Need Assistance: Command to display procedures does not work