Summary
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.
Question
Hey,
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.