Creating partitions with long names within a transaction fails with distributed deadlock

This behavior is limited to inside transactions (including when using anonymous functions).

This is most likely related to these fixed issues:

https://github.com/citusdata/citus/issues/1664
https://github.com/citusdata/citus/issues/4739
https://github.com/citusdata/citus/pull/4794

Reproduction script:

```
BEGIN;
create table name_lengths(a int);
insert into name_lengths select i from generate_series(0,10000)i;
ALTER TABLE name_lengths RENAME TO name_len_12345678901234567890123456789012345678901234567890;
select create_distributed_table('name_len_12345678901234567890123456789012345678901234567890', 'a');
COMMIT;
```
Script output:
```
BEGIN
CREATE TABLE
INSERT 0 10001
ALTER TABLE
ERROR: canceling the transaction since it was involved in a distributed deadlock
ROLLBACK
```