Re: After an error - pg_replication_slot is dropped

2018-02-16 Thread Petr Jelinek
On 16/02/18 12:38, tushar wrote: > On 02/16/2018 04:02 PM, Petr Jelinek wrote: >> It's because you are creating temporary slot. Temporary slots are >> removed on error, that's a documented behavior. > > Thanks for pointing out but It looks weird behavior - even a small mea > culpa can remove the s

Re: After an error - pg_replication_slot is dropped

2018-02-16 Thread tushar
On 02/16/2018 04:02 PM, Petr Jelinek wrote: It's because you are creating temporary slot. Temporary slots are removed on error, that's a documented behavior. Thanks for pointing out but It looks weird behavior - even a small mea culpa can remove the slot. Temporary table - doesn't go automatic

Re: After an error - pg_replication_slot is dropped

2018-02-16 Thread Petr Jelinek
Hi, On 16/02/18 10:51, tushar wrote: > Hi, > > Please refer this straight forward scenario  against latest sources of v11. > > [centos@centos-cpula bin]$ ./psql  postgres > psql (11devel) > Type "help" for help. > > postgres=#  SELECT * FROM > pg_create_logical_replication_slot('regression_slot

After an error - pg_replication_slot is dropped

2018-02-16 Thread tushar
Hi, Please refer this straight forward scenario  against latest sources of v11. [centos@centos-cpula bin]$ ./psql  postgres psql (11devel) Type "help" for help. postgres=#  SELECT * FROM pg_create_logical_replication_slot('regression_slot1', 'test_decoding', true);     slot_name |    lsn