Postgres 15 strictness
parsonsmatt opened this issue · 0 comments
parsonsmatt commented
I'm running into an error where I do, basically,
select do
t <- from table
limit 1
forUpdateOf t skipLocked
pure t
The generated SQL looks like:
SELECT *
FROM table
LIMIT 1FOR UPDATE OF t SKIP LOCKED
Note the 1FOR
there. Postgres prior to 15 accept this, but Postgres 15 errors.
Looks like makeOrderBy
inserts a newline, but makeLocking
does not put a newline in.