Administrace komentářů

postgres=# \df+ pglogical.show_subscription_status
List of functions
-[ RECORD 1 ]-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Schema              | pglogical
Name                | show_subscription_status
Result data type    | SETOF record
Argument data types | subscription_name name DEFAULT NULL::name, OUT subscription_name text, OUT status text, OUT provider_node text, OUT provider_dsn text, OUT slot_name text, OUT replication_sets text[], OUT forward_origins text[]
Type                | normal
Security            | invoker
Volatility          | stable
Owner               | postgres
Language            | c
Source code         | pglogical_show_subscription_status
Description         | 

postgres@mypostgres:~$ psql mydb
psql (9.5.19)
Type "help" for help.

mydb=# SHOW search_path;
-[ RECORD 1 ]----------------
search_path | "$user", public

mydb=# SET search_path TO pglogical;
SET
mydb=# SHOW search_path;
-[ RECORD 1 ]----------
search_path | pglogical

mydb=# \dn+
List of schemas
-[ RECORD 1 ]-----+-----------------------
Name              | pglogical
Owner             | postgres
Access privileges | 
Description       | 
-[ RECORD 2 ]-----+-----------------------
Name              | public
Owner             | postgres
Access privileges | postgres=UC/postgres  +
                  | =UC/postgres
Description       | standard public schema

mydb=# grant execute on function pglogical.show_subscription_status() to myuser;
ERROR:  function pglogical.show_subscription_status() does not exist

mydb=# SELECT subscription_name, status FROM pglogical.show_subscription_status();
-[ RECORD 1 ]-----+-------------------
subscription_name | mydb_partial_set
status            | replicating