{"action":"created","issue":{"url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/60","repository_url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters","labels_url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/60/labels{/name}","comments_url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/60/comments","events_url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/60/events","html_url":"https://github.com/jcachat/EntityFramework.DynamicFilters/issues/60","id":145668842,"number":60,"title":"AlterTableAnnotations code first migration fails on **postgres**","user":{"login":"tiwariarvin","id":4313475,"avatar_url":"https://avatars.githubusercontent.com/u/4313475?v=3","gravatar_id":"","url":"https://api.github.com/users/tiwariarvin","html_url":"https://github.com/tiwariarvin","followers_url":"https://api.github.com/users/tiwariarvin/followers","following_url":"https://api.github.com/users/tiwariarvin/following{/other_user}","gists_url":"https://api.github.com/users/tiwariarvin/gists{/gist_id}","starred_url":"https://api.github.com/users/tiwariarvin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tiwariarvin/subscriptions","organizations_url":"https://api.github.com/users/tiwariarvin/orgs","repos_url":"https://api.github.com/users/tiwariarvin/repos","events_url":"https://api.github.com/users/tiwariarvin/events{/privacy}","received_events_url":"https://api.github.com/users/tiwariarvin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-04-04T12:24:57Z","updated_at":"2016-04-12T12:32:28Z","closed_at":null,"body":"Is there a work around?\r\n\r\nI am getting error = \"Unhandled MigrationOperation AlterTableOperation in NpgsqlMigrationSqlGenerator\"\r\n\r\nStack trace on PM -\r\nApplying explicit migration: 201604041142031_test.\r\nSystem.NotImplementedException: Unhandled MigrationOperation AlterTableOperation in NpgsqlMigrationSqlGenerator\r\n   at Npgsql.NpgsqlMigrationSqlGenerator.Convert(IEnumerable`1 operations)\r\n   at Npgsql.NpgsqlMigrationSqlGenerator.Generate(IEnumerable`1 migrationOperations, String providerManifestToken)\r\n   at System.Data.Entity.Migrations.DbMigrator.GenerateStatements(IList`1 operations, String migrationId)\r\n   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.GenerateStatements(IList`1 operations, String migrationId)\r\n   at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto)\r\n   at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)\r\n   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration)\r\n   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)\r\n   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)\r\n   at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)\r\n   at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b()\r\n   at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)\r\n   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)\r\n   at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)\r\n   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)\r\n   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()\r\n   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)\r\n   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)\r\n   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)\r\n   at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)\r\n   at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()\r\n   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)"},"comment":{"url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/comments/208881096","html_url":"https://github.com/jcachat/EntityFramework.DynamicFilters/issues/60#issuecomment-208881096","issue_url":"https://api.github.com/repos/jcachat/EntityFramework.DynamicFilters/issues/60","id":208881096,"user":{"login":"jcachat","id":1613260,"avatar_url":"https://avatars.githubusercontent.com/u/1613260?v=3","gravatar_id":"","url":"https://api.github.com/users/jcachat","html_url":"https://github.com/jcachat","followers_url":"https://api.github.com/users/jcachat/followers","following_url":"https://api.github.com/users/jcachat/following{/other_user}","gists_url":"https://api.github.com/users/jcachat/gists{/gist_id}","starred_url":"https://api.github.com/users/jcachat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcachat/subscriptions","organizations_url":"https://api.github.com/users/jcachat/orgs","repos_url":"https://api.github.com/users/jcachat/repos","events_url":"https://api.github.com/users/jcachat/events{/privacy}","received_events_url":"https://api.github.com/users/jcachat/received_events","type":"User","site_admin":false},"created_at":"2016-04-12T12:32:27Z","updated_at":"2016-04-12T12:32:27Z","body":"The library stores information about the filter by adding a \"Convention\" to it.  That Convention adds a Table Annotation which contains information about the filter.  None of this should be written to the database!  The Conventions are applied by the Filter() commands in OnModelCreating().  I have not seen any other database driver attempt to do that.\r\n\r\nThe Conventions/Table Attributes are not for performance reasons.  This is how we attach information about the filter to the underlying EF entities so that we can get the filter definitions when the query is being executed.  It is not possible to do this any other way that I know of.\r\n\r\nI had not specifically tested against Postgres, but another user did (see #44) and it was working...  He was on 9.3 and you are on 9.4.  Maybe it's a driver change.  Is it possible for you to try rolling back to 9.3 to see if that works to at least determine if it's a driver change?  \r\n"}}