harikrishna12524 commented on issue #49761: URL: https://github.com/apache/airflow/issues/49761#issuecomment-2836046579
@atul-astronomer The error is actually thrown from the Postgres adapter, when trying to use the connection to execute create table statement in postgres Database. The connection is created in the apache-airflow connection list, which doesn't validate the extras property against the specific SQL server's parameters. So, there is not issue in creating a connection. When creating a postgres connection, airflow provides the connection parameters along with extra object to postgres client module, which internally checks for valid parameters. That is why you are getting issue when executing the SQL, not during connection creation. airflow is using [psycopg2](https://www.psycopg.org/docs/) to connect to postgresSQL server. https://www.psycopg.org/docs/module.html#psycopg2.ProgrammingError. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
