[YSQL] Partitions still create tables on pg-side failures

[hulien22]

Jira Link: DB-11262
Partitions seem to still create a docdb table despite failing a cast check -- should be doing this check before creating the table

CREATE TABLE moneyp (a money) PARTITION BY LIST (a);
-- this fails due to invalid cast but still creates (and drops) a new table
CREATE TABLE moneyp_10 PARTITION OF moneyp FOR VALUES IN (10); 

Similarly, partitions also create a docdb table if there's a failure due to overlap:

CREATE TABLE bigintp (a bigint) PARTITION BY LIST (a);
CREATE TABLE bigintp_10 PARTITION OF bigintp FOR VALUES IN (10);
-- fails due to overlap:
CREATE TABLE bigintp_10_2 PARTITION OF bigintp FOR VALUES IN ('10');

These examples are taken from create_table.sql in pgregress, there are some other similar examples there as well