Error using parameters with `ALTER SEQUENCE`

[busslina]

This does not works:

final res = await executor(
  Sql.named(
    'ALTER SEQUENCE auth.user_short_id_sequence RESTART WITH @newShortId',
    // 'ALTER SEQUENCE auth.user_short_id_sequence RESTART WITH 1200',
  ),
  parameters: {
    'newShortId': newShortId,
  },
);

newShortId is int.

Severity.error 42601: syntax error at or near "$1"

This works:

final res = await executor(
  Sql.named(
    // 'ALTER SEQUENCE auth.user_short_id_sequence RESTART WITH @newShortId',
    'ALTER SEQUENCE auth.user_short_id_sequence RESTART WITH 1200',
  ),
  // parameters: {
  //   'newShortId': newShortId,
  // },
);

[isoos]

I think, memory might be vague, that DDL commands in QueryMode.extended may not be supported by the Postgresql server. They must be used in simple mode, which doesn't allow parameters.

[busslina]

PostgreSQL version: psql (PostgreSQL) 15.14