search

JasperFx / weasel

Database Development Made Easy for .Net
MIT License
65 stars 19 forks source link

Dropping materialized view fails. #90

Closed masterpoi closed 1 year ago

masterpoi commented 1 year ago

This should probably be writer.WriteLine($"DROP {ViewType} IF EXISTS {Identifier.QualifiedName};");

https://github.com/JasperFx/weasel/blob/3f957c27d6b124d87af64d8c462b93227487287e/src/Weasel.Postgresql/Views/View.cs#L73

Otherwise:

Npgsql.PostgresException (0x80004005): 42809: "<view name>" is not a view
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|234_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(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   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 Weasel.Postgresql.PostgresqlMigrator.executeDelta(SchemaMigration migration, DbConnection conn, AutoCreate autoCreate, IMigrationLogger logger, CancellationToken ct)