Starting Docker Image fails due to error in pagila deployment

[jischebeck]

Hi.

Pagila DB creation fails:

2018-04-27 16:13:01.454 UTC [45] ERROR: cannot create index on partitioned table "payment"
2018-04-27 16:13:01.454 UTC [45] STATEMENT: CREATE INDEX idx_fk_customer_id ON payment USING btree (customer
psql:/docker-entrypoint-initdb.d/pagila.sql:1102: ERROR: cannot create index on partitioned table "payment"

Used command:
docker run --name pg-ds -p 5432:5432 aa8y/postgres-dataset:latest

Jan

[aa8y]

Sorry about this. I'll take a look this weekend.

[aa8y]

I apologize I am unable to get to it anytime soon. However if you have a fix for it, please feel free to open a PR.

[aa8y]

I am sorry it has been a while since I could take a look at this. Looks like there are problems with the SQL file we use for the Paglia data source. I've created an issue for that (see this). Let's see if there is any action. Otherwise I might try and create a PR.

[fzaninotto]

I have the same issue. Your image isn't usable because of that bug 🤕

[fzaninotto]

I suggest you remove the pagila dataset if you can't fix the bug.

[aa8y]

@fzaninotto I'll take a look this week. Sorry about the problem.

[aa8y]

@jischebeck and @fzaninotto Pagila dataset and tag has been removed in the latest release. This should now be fixed, if I can call it that :)

[fzaninotto]

I confirm the latest image has no more problem. Thanks a lot, you can close this issue!

[aa8y]

Closing as the problem has been resolved.