While updating my development environment, I (casually) upgraded my Postgres to 17; the sqlxmq migrations failed with an "undefined function: uuid_nil" error at https://github.com/Diggsey/sqlxmq/blob/master/migrations/20210316025847_setup.up.sql#L54. Running the migration directly in psql suggested there was something about inlining a function as the context of the error.
I'm sorry, I should have captured the error text at the time; I wound up rolling back to postgresql_15 for now. More than anything I'm providing this as a heads up - there's a change in behavior in newer PostgreSQL that breaks the mq setup migration. select uuid_nil() in the same database worked fine, so I'm unclear what the issue is.
While updating my development environment, I (casually) upgraded my Postgres to 17; the sqlxmq migrations failed with an "undefined function: uuid_nil" error at https://github.com/Diggsey/sqlxmq/blob/master/migrations/20210316025847_setup.up.sql#L54. Running the migration directly in
psqlsuggested there was something about inlining a function as the context of the error.I'm sorry, I should have captured the error text at the time; I wound up rolling back to postgresql_15 for now. More than anything I'm providing this as a heads up - there's a change in behavior in newer PostgreSQL that breaks the mq setup migration.
select uuid_nil()in the same database worked fine, so I'm unclear what the issue is.