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=>
> On Feb 28, 2024, at 8:53 AM, Sasmit Utkarsh <utkarshsasmit@gmail.com> 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@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.
The version difference between your psql client installation and the server installation is the problem.