Error connecting Postgres to Postgres - relation error

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error message indicates an issue with relation ‘snip_raw__stream_user_organizationplatformprofile_categories_’ in the connector. It seems to be related to an unsupported operation for indexes.


Question

I set up a new postgres to postgres connection, but getting this error:

  Detail: This operation is not supported for indexes.```
What can I do about this?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1725869382251609) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["error", "postgres-to-postgres-connection", "relation-error", "index"]
</sub>
2

This seems to only happen with long table names, although the connector is supposed to auto-truncate those. Note that I changed one word of 6 letter length to snip in the log message above. It looks like a bug in the Postgres destination connector.

3

I found the root cause of the issue, so I opened an https://github.com/airbytehq/airbyte/issues/45345|issue in Github