Files
yii2/tests/data/postgres10.sql
Evgeny 09eacd8dc1 Bug #17597: PostgreSQL 12 and partitioned tables support (batyrmastyr)
* yiisoft#17597, pg_constraint.consrc removed in Postgres 12

* yiisoft#17597, load schema for partitioned tables (introduced in Postgres 10)

* messed up with issue number

* #yiisoft#17597 Postgres 12 support, support GENERATED AS IDENTITY columns

* uncleared FileCache leads to falsy failures on subsequent test runs

* moved .sql for postgres 10 and 12 to separate files, added ResetSequence test for GENERATED AS IDENTITY column
2019-10-18 14:57:24 +03:00

6 lines
171 B
SQL

DROP TABLE IF EXISTS "partitioned" CASCADE;
CREATE TABLE "partitioned" (
city_id int not null,
logdate date not null
) PARTITION BY RANGE ("logdate");