Re: PgLogical 1.1 feedback

On 05/18/2016 01:17 PM, Joshua D. Drake wrote:

And then there are things like this:

postgres=# \c logical
You are now connected to database "logical" as user "postgres".
logical=# select * from pglogical.node;
-[ RECORD 1 ]----------
node_id   | 3276292710
node_name | replica2
-[ RECORD 2 ]----------
node_id   | 2125761069
node_name | subscriber0

logical=# select pglogical.drop_node(node_name := 'replica2');
ERROR:  cannot drop node "replica2" because it still has subscriptions 
associated with it
HINT:  drop the subscriptions first
logical=# select * from pglogical.subscription ;
-[ RECORD 1 ]--------+--------------------------------------
sub_id               | 1763399739
sub_name             | subscription1
sub_origin           | 2125761069
sub_target           | 3276292710
sub_origin_if        | 2466493301
sub_target_if        | 182959776
sub_enabled          | t
sub_slot_name        | pgl_logical_subscriber0_subscription1
sub_replication_sets | {default,default_insert_only,ddl_sql}
sub_forward_origins  | {all}

logical=# select pglogical.drop_subscription(subscription_name := 
'subscription1');


The last function call never returns, it will just hang indefinitely.

Sincerely,

JD
-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.