Down with a Sequence generated in incorrect order

[pdevito3]

File a bug

Include your code

I have a config like this:

        modelBuilder.HasSequence<long>(Consts.DatabaseSequences.ConferenceOrderNoSequence)
            .StartsAt(10000000) /
            .IncrementsBy(1);

// .....

    public void Configure(EntityTypeBuilder<Conference> builder)
    {
        builder.Property(o => o.OrderNo)
            .HasDefaultValueSql($"concat('CONF', nextval('\"{Consts.DatabaseSequences.ConferenceOrderNoSequence}\"'))")
            .IsRequired();
    }

that generates a migration like this

        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateSequence(
                name: "ConferenceOrderNumbers",
                startValue: 10000000L);

            migrationBuilder.AddColumn<string>(
                name: "order_no",
                schema: "event",
                table: "event",
                type: "text",
                nullable: false,
                defaultValueSql: "concat('CONF', nextval('\"ConferenceOrderNumbers\"'))");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {            
            migrationBuilder.DropSequence(
                name: "ConferenceOrderNumbers");

            migrationBuilder.DropColumn(
                name: "order_no",
                schema: "event",
                table: "event");
        }

I can easily resolve this manually by switching the order to this, but knowing and remembering to do that isn't ideal:

        protected override void Down(MigrationBuilder migrationBuilder)
        {            
            migrationBuilder.DropColumn(
                name: "order_no",
                schema: "event",
                table: "event");

            migrationBuilder.DropSequence(
                name: "ConferenceOrderNumbers");
        }

Include stack traces

Include the full exception message and stack trace for any exception you encounter.

Use triple-tick fences for stack traces. For example:

DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult()
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteNonQuery()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
  Exception data:
    Severity: ERROR
    SqlState: 2BP01
    MessageText: cannot drop sequence "ConferenceOrderNumbers" because other objects depend on it
    Detail: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
    Hint: Use DROP ... CASCADE to drop the dependent objects too.
    File: dependency.c
    Line: 1195
    Routine: reportDependentObjects
2BP01: cannot drop sequence "ConferenceOrderNumbers" because other objects depend on it

Include provider and version information

EF Core version:
Database provider: postgres
Target framework: .NET 6
Operating system: MacOS 12.4
IDE: Rider 22.1