Summary
The user is encountering an error ‘function airbyte_safe_cast already exists’ when trying to use the PostgreSQL connector to connect Airtable to a PostgresDB hosted on Supabase via Airbyte cloud. The user has verified that the function doesn’t exist and checked the connector code.
Question
I’m trying to use connector airtable to a postgresDB destination hosted on supabase using Airbyte cloud
I keep getting this error on the PostgreSQL connector:
ERROR: function “airbyte_safe_cast” already exists with the same argument types
at http://org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse/|org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(http://queryexecutorimpl.java:2713/|QueryExecutorImpl.java:2713)
I tested with other sources, and I got the same error.
I checked that the function doesn’t exist (and that shouldn’t be a problem, as I’ve looked through the connector code and it creates the function temporarily https://github.com/airbytehq/airbyte/blob/3b3392317f166fecb8723531054c0c745865142b/airbyte-integrations/connectors/destination-postgres/src/main/java/io/airbyte/integrations/destination/postgres/PostgresDestination.java#L76|https://github.com/airbytehq/airbyte/blob/3b3392317f166fecb8723531054c0c745865142b[…]byte/integrations/destination/postgres/PostgresDestination.java)
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.