What is your product version? 13
What is your product type (Angular or MVC)? MVC
What is product framework type (.net framework or .net core)? .net core
.EntityFrameworkCore dependencies
Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.0" Abp.EntityFrameworkCore.EFPlus" Version="9.0.0" Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.0" Microsoft.EntityFrameworkCore.Tools" Version="8.0.0" OpenIddict.EntityFrameworkCore" Version="4.10.0"
#################################################
Dear Ismcagdas,
I follow this tutorial and I facing same Issue.
steps I already did it:
the generating code for migration is not valid to PostgreSQL
migrationBuilder.CreateIndex(
name: "IX_AppSubscriptionPaymentsExtensionData_SubscriptionPaymentId_~",
table: "AppSubscriptionPaymentsExtensionData",
columns: new[] { "SubscriptionPaymentId", "Key", "IsDeleted" },
unique: true,
filter: "[IsDeleted] = 0");
Exception:
Exception data: Severity: ERROR SqlState: 42601 MessageText: syntax error at or near "[" Position: 181 File: scan.l Line: 1245 Routine: scanner_yyerror 42601: syntax error at or near "["
When I Remove Square bracket it's show me another exception
Exception data: Severity: ERROR SqlState: 42703 MessageText: column "isdeleted" does not exist Hint: Perhaps you meant to reference the column "AppSubscriptionPaymentsExtensionData.IsDeleted". Position: 181 File: parse_relation.c Line: 3729 Routine: errorMissingColumn
When I take has hint to add AppSubscriptionPaymentsExtensionData.IsDeleted it's show me another exception missing FROM-clause entry for table "appsubscriptionpaymentsextensiondata"
Exception data: Severity: ERROR SqlState: 42P01 MessageText: missing FROM-clause entry for table "appsubscriptionpaymentsextensiondata" Position: 181 File: parse_relation.c Line: 3652 Routine: errorMissingRTE