Cannot run pagila-schema.sql in Postgres 10.5

[aa8y]

Error

2018-09-30 18:42:09.856 UTC [38] ERROR:  cannot create index on partitioned table "payment"
2018-09-30 18:42:09.856 UTC [38] STATEMENT:  CREATE INDEX idx_fk_customer_id ON payment USING btree (customer_id);
psql:/docker-entrypoint-initdb.d/pagila.sql:1102: ERROR:  cannot create index on partitioned table "payment"

How to reproduce

1. Install Docker.
2. Run docker run --rm aa8y/postgres-dataset:pagila

Code

See this and this

[sumodirjo]

Hello,
I tried to import pagila schema on PostgreSQL 10.11 on Ubuntu 16.04 (PostgreSQL 10.11 (Ubuntu 10.11-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit). Still got the following error message

ERROR:  cannot create index on partitioned table "payment"

Googling found [1] that refer to [2] which states basically local partitioned indexes support start from postgresql 11.

Do you mind to recheck and confirm about this @devrimgunduz ? perhaps updating README with limitation that this require PostgreSQL 11 to be run properly. Thank you.

[1] https://blog.dbi-services.com/local-partitioned-indexes-in-postgresql-11/
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8b08f7d4820fd7a8ef6152a9dd8c6e3cb01e5f99

[devrimgunduz]

Hi,

Thanks for the heads up. README now mentions that pagila can be used on PG 11+

Regards, Devrim