citusdata / citusdata/cstore_fdw

Check if $PGDATA/cstore_fdw/<oid> folder exists

Open
#124 8 comments 0 reactions 0 assignees View on GitHub
fixed-in-development-version
Dominant language
C
Stars
1.8k
Forks
169
PR merge metrics
No merged PRs in 30d

Description

Hello,

I want to have cstore_fdw to part of all the databases I create, so I installed this to template1 database.

When creating a new database it doesn't create a folder under cstore_fdw, and I receive an error:
`ERROR: could not open file "/data1/pgsql/data/cstore_fdw/2813186/2813202" for writing: No such file or directory`

To fix this I created a folder with the oid name of my database, and this fixed the problem.

Can we enhance the fdw to check this?

Also what would be the command I have to execute to create that folder from the database (i.e. using SQL)

Regards,
Balazs

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.