>are there any drawbacks in using 9.6 client with 10.0 server?
A simple declarative partitioning example for the differences:
root@a5c0a6414f2e:/# psql
psql (10.1)
Type "help" for help.
test=# CREATE TABLE measurement (
test(# city_id int not null,
test(# logdate date not null,
test(# peaktemp int,
test(# unitsales int
test(# ) PARTITION BY RANGE (logdate);
CREATE TABLE
test=#
test=# CREATE TABLE measurement_y2006m02 PARTITION OF measurement
test-# FOR VALUES FROM ('2006-02-01') TO ('2006-03-01');
CREATE TABLE
test=# \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+----------------------+-------+-------+---------+-------------
public | measurement | table | test | 0 bytes |
public | measurement_y2006m02 | table | test | 0 bytes |
(2 rows)
Connecting from 9.6 - I can see only 1 table
root@cf0ddd0a1d58:/# psql
psql (9.6.6, server 10.1)
WARNING: psql major version 9.6, server major version 10.
Some psql features might not work.
Type "help" for help.
test=# \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+----------------------+-------+-------+---------+-------------
public | measurement_y2006m02 | table | test | 0 bytes |
(1 row)
Regards,
Imre