Error when landing data to Postgres for existing tables


Error occurs when trying to land data to Postgres for existing tables, with ‘relation already exists’ error. Issue seems to be related to table dropping permissions.


I have a brand new installation of Airbyte, and I’m trying to land data to Postgres for existing tables, and I get the following error for all connectors:
“org.postgresql.util.PSQLException: ERROR: relation “src_table_name” already exists”

It appears it can’t drop any table, however, when I use the same SQL account, I can drop these tables. And then it will load just fine.
I’ve never seen this issue before, I don’t think it’s related to the specific Postgres Destination version (which is 2.0.0) because I have it working on another Airtable instance.

Any ideas?

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["error", "landing-data", "postgres-connector", "table-exists"]

It appears to be a bug with the latest Postgres version as I found this issue…
Downgrading the Postgres version resolved my issue.