Postgres tables created with declarative partitioning option are not accessible

[guyco33]

Since 364, Postgres tables created with the declarative partitioning option (10+) are not accessible.

Postgres 10+

CREATE TABLE test_part_tbl (
    id         int not null,
    logdate    date not null,
    payload    varchar
) PARTITION BY RANGE (logdate)

Trino 363

SHOW TABLES FROM postgres.public LIKE 'test_part_tbl'
('test_part_tbl',)

Trino 354+

SHOW TABLES FROM postgres.public LIKE 'test_part_tbl'
no result

I guess it's somehow related to bumping JDBC driver from 42.2.10 to 42.2.14

Tests for declarative partitioning cannot be done until Postgres docker will bump from 9.6 to 10+

The following test pass in 363 and fails in 364+

[guyco33]

@hashhar

[findepi]

Tests for declarative partitioning cannot be done until Postgres docker will bump from 9.6 to 10+

We should test with both: oldest and newest supported PostgreSQL version.
See BaseElasticsearchConnectorTest (perhaps this should use BaseConnectorSmokeTest instead.)

[guyco33]

10.x is the oldest supported version, so splitting tests is not relevant for partitioned tables.