ewan-escience

Thanks for the quick reply. I'm trying to move away from [migra](https://github.com/djrobstep/migra), as it isn't developed anymore and doesn't support diffing [domains](https://www.postgresql.org/docs/current/sql-createdomain.html). Migra would always add `set check_function_bodies = off;`...

To be more precise, an empty array is returned. When also using header key `Accept` and value `application/vnd.pgrst.object+json`, the error message `{"code":"PGRST116","details":"The result contains 0 rows","hint":null,"message":"JSON object requested, multiple (or...

> My assumption is, that no rows are actually inserted, all are already there and the duplicates ignored. Indeed, but I still want the existing rows to be returned. Those...

> There are some challenges around running a SELECT and an INSERT on the same table in the same statement, because the SELECT wouldn't see the rows that were inserted....

When using `pg-schema-diff` to (as a test only) migrate the [RSD](https://github.com/research-software-directory/RSD-as-a-service) from version [5.1.0](https://github.com/research-software-directory/RSD-as-a-service/tree/v5.1.0/database) to version [5.2.0](https://github.com/research-software-directory/RSD-as-a-service/tree/v5.2.0/database), I get the following error message: ``` Error: generating plan: generating plan statements:...

I also prefer option 2. 😉

The point is to *not* update them automatically. But this would indeed require some regular maintenance. If you don't think it's worth the effort, that's also fine, but I wanted...

From [this issue](https://github.com/dependabot/dependabot-core/issues/3228), this does not seem to be supported (yet) by dependabot and I haven't found any other tool that can do this, so it looks like we would...

Hmm, if I understand correctly from [this](https://docs.renovatebot.com/modules/manager/cdnurl/) and [this](https://docs.renovatebot.com/modules/datasource/cdnjs/), [cdnjs](https://cdnjs.com/) is supported, but we use [jsDelivr](https://www.jsdelivr.com/), which is [apparently not yet supported](https://github.com/renovatebot/renovate/issues/26936). Maybe we can switch to cdnjs. If we...

I don't think that could be a one-liner, due to the order of pattern and text in [`ILIKE`](https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE) and the order of expression and array for [`ANY`](https://www.postgresql.org/docs/current/functions-comparisons.html#FUNCTIONS-COMPARISONS-ANY-SOME). I would hope...