`Connect To Database` fails with psycopg (v3) due to invalid connection parameter mapping

[alsastre]

Bug Description

When using Connect To Database with psycopg (psycopg v3), the following error is raised:

ProgrammingError: invalid connection option "database"

Root Cause

The library internally maps the db_name parameter to database when building the connection kwargs. However, psycopg v3 (psycopg==3.x) expects dbname instead of database. This mapping works for other drivers but is incompatible with psycopg3.

Steps to Reproduce

Connect To Database
...    psycopg
...    db_name=mydb
...    db_user=myuser
...    db_password=mypassword
...    db_host=localhost
...    db_port=5432

Environment

• psycopg==3.3.3
• psycopg-binary==3.3.3
• Robot Framework DatabaseLibrary

Expected Behavior

Connect To Database should work with psycopg v3 by using dbname instead of database in the connection kwargs.

Workaround

Using Connect To Database Using Custom Params with explicit psycopg3 parameter names works correctly:

Connect To Database Using Custom Params
...    psycopg
...    dbname='mydb',user='myuser',password='mypassword',host='localhost',port=5432

Suggested Fix

When the connector is psycopg (v3), the internal parameter mapping should use dbname instead of database.

[amochin]

Hello @alsastre, thanks for submitting the issue!

The psycopg v3 module is not natively supported right now. The support might be added lately - mapping the „db_name“ keyword argument to the „dbname“ connection parameter.

However, as the „Connect to database“ keyword supports any custom arguments since a couple of versions, you might already try to provide the „dbbame“ argument directly - it should work.

The custom parameters functionality in the „Connect to database“ keyword replaces the deprecated „Connect To Database Using Custom Params“ keyword.

Could you please try and let me know if it works?
Thanks!

[alsastre]

Sure, let me test it and get back to you.