Cannot execute SELECT statements in migrations. about migratus

[eraserhd]

A useful work-around for PostgreSQL 9+ appears to be:

DO $$
BEGIN
  PERFORM my_function();
END$$;

[pjstadig]

I think that's probably the way you would have to do it. Migratus is calling the clojure.java.jdbc do-commands function, so it isn't expecting a result set to be returned.

[apennebaker-ni]

JDBC borks on double dollar ($$)-quoted strings, so Java users may want to use single quotes (') instead, e.g.:

-- work around JDBC 'A result was returned when none was expected.'
DO '
BEGIN
  -- fix broken nextval due to poorly written 20140320100000_CreateAdminUserRoleTables.sql
  PERFORM setval(''admin_user_role_groups_id_seq'', 1 + COALESCE(MAX(id), 0), FALSE) FROM admin_user_role_groups;
END; ';