Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Relation 'pg_indexes' unknown #11697

Closed
amotl opened this issue Sep 2, 2021 · 1 comment · Fixed by #11706
Closed

Relation 'pg_indexes' unknown #11697

amotl opened this issue Sep 2, 2021 · 1 comment · Fixed by #11706
Assignees
@mfussenegger
Labels
complexity: no estimate feature: integration Better integration with other systems feature: pgsql

Comments

@amotl
Copy link
Member

amotl commented Sep 2, 2021

Hi there,

this is merely a notice where the compatibility with PostgreSQL can be improved.

On behalf of crate/cratedb-examples#4, I conducted some experiments about how to export data from InfluxDB and import into CrateDB the other day.

The outcome was that the influxdb-write-to-postgresql program croaked with ERROR: Relation 'pg_indexes' unknown, when trying to import data into CrateDB.

With kind regards,
Andreas.
@amotl amotl added the triage An issue that needs to be triaged by a maintainer label Sep 2, 2021
@amotl amotl mentioned this issue Sep 2, 2021
Draft
@mfussenegger mfussenegger added complexity: no estimate feature: integration Better integration with other systems feature: pgsql and removed triage An issue that needs to be triaged by a maintainer labels Sep 6, 2021
@mfussenegger mfussenegger self-assigned this Sep 7, 2021
mfussenegger added a commit that referenced this issue Sep 7, 2021
@mfussenegger
Add an empty pg_catalog.pg_indexes table
2ac7995 
Closes #11697

Given that there are no `CREATE INDEX` statements in CrateDB the table
is empty.
@mfussenegger mfussenegger mentioned this issue Sep 7, 2021
Merged
5 tasks
mfussenegger added a commit that referenced this issue Sep 7, 2021
@mfussenegger
Add an empty pg_catalog.pg_indexes table
95c8c4d 
Closes #11697

Given that there are no `CREATE INDEX` statements in CrateDB the table
is empty.
@amotl
Copy link
Member Author

amotl commented Sep 7, 2021

Dear @mfussenegger,

thank you for providing an improvement through #11706 so quickly. I will let you know about the outcome with respect to crate/cratedb-examples#4.

With kind regards,
Andreas.

mfussenegger added a commit that referenced this issue Sep 8, 2021
@mfussenegger
Add an empty pg_catalog.pg_indexes table
6ac0761 
Closes #11697

Given that there are no `CREATE INDEX` statements in CrateDB the table
is empty.
@mergify mergify bot closed this as completed in #11706 Sep 8, 2021
mergify bot pushed a commit that referenced this issue Sep 8, 2021
@mfussenegger @mergify
Add an empty pg_catalog.pg_indexes table
5f18491 
Closes #11697

Given that there are no `CREATE INDEX` statements in CrateDB the table
is empty.
@rafaelasantana rafaelasantana mentioned this issue Sep 14, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mfussenegger mfussenegger

Labels
complexity: no estimate feature: integration Better integration with other systems feature: pgsql
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add an empty pg_catalog.pg_indexes table crate/crate
2 participants
@mfussenegger @amotl