Feature-Request: Implementing DatabaseMetaData.getPrimaryKeys()

[prrvchr]

Hi all,

It's good, I manage to make the ResultSet coming from Trino editable by SQL commands generated when calling the methods allowing positioned updates on the ResultSet.

In order to work around issue #22306 I obtain the name of the catalog, the schema and the table of the ResultSet columns using the DatabaseMetaData.getColumns() method.

But since Trino does not support multiple predicates in SQL commands (ie: no AND in WHERE clauses), it is imperative for me to know the name of the primary key in order to be able to make table updatable in LibreOffice Base without knowing the structure of the edited tables.

This seems possible to me, only if I have access to the DatabaseMetaData.getPrimaryKeys() method, and which currently provides no data.

Would it be possible to have this method implemented?

[prrvchr]

Well, jdbcDriverOOo version 1.4.0 finally manages to edit the tables and Base queries coming from the Trino driver.

The implementation is not optimal because I am obliged to find the primary key of each ResultSet and consider that the first column not containing a duplicate is the primary key. This is not necessarily true and can therefore pose problems.

I think if we want something more robust then we would need access to the DatabaseMetaData.getPrimaryKeys() method.