PgstacCLI.loadextensions "UPDATE pgstac.stac_extensions" does not work

[jgaucher-cs]

Hi, after some testing in my environment, it seems that the PgstacCLI.loadextensions method part that does the "UPDATE pgstac.stac_extensions" does not work, the changes are not committed in the database: https://github.com/stac-utils/pgstac/blob/v0.9.1/src/pypgstac/python/pypgstac/pypgstac.py#L109

Should we use cur.execute instead of self._db.query to be able to commit this update ?

Thank you :)