Re: Need Assistance: Command to display procedures does not work

[Sasmit Utkarsh <utkarshsasmit@xxxxxxxxx>]

Thanks Rob

So which one could I rely on for better information? probably, results shown by PgAdmin4 right? As  I get the below when I try to drop procedure through psql cmd and i see the procedure getting fetched from the query

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)

shc_data=> DROP PROCEDURE sql_insert_data_procedure;
ERROR:  could not find a procedure named "sql_insert_data_procedure"
shc_data=>

Regards,

Sasmit Utkarsh

+91-7674022625

On Wed, Feb 28, 2024 at 10:25 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:

> On Feb 28, 2024, at 8:53 AM, Sasmit Utkarsh <utkarshsasmit@xxxxxxxxx> wrote:
>
> 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@xxxxxxxxxxxxxxxxxxxxxxxxxx@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.

The version difference between your psql client installation and the server installation is the problem.