migration-syntax-woes.md

Code:

-- 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; ';

Trace:

ERROR: unterminated quoted string at or near "' BEGIN PERFORM setval(''admin_user_role_groups_id_seq'', 1 + COALESCE(MAX(id), 0), FALSE) FROM admin_user_role_groups"
  Position: 4

JDBC is really quite dumb, mistakenly thinking that the semicolon after END terminates the begin, because of a line break.

The solution is to write the do ... end all in a single line:

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