KorzhCom/Korzh.DbUtils

NPGSQL return table name in lower case

Closed this issue · 5 comments

https://github.com/kedonec/Korzh.DbUtils/blob/cf6517d32821292596fb11fa85a4242ee730e6ab/src/Korzh.DbUtils.PostgreSql/PostgreBridge.cs#L192

we have

Npgsql.PostgresException: 42P01: relation "SOME" does not exist

because entity-framework create table in PascalCase

step to reproduce

  1. create table in postgresql database
CREATE TABLE public."SomeInCamelCase"
(
    "Id" uuid NOT NULL,
    "Name" text COLLATE pg_catalog."default"
}
  1. export
dbtool connections add development postgre "<ConnectionString>"
dbtool.exe filter-tables development "SomeInCamelCase"
dbtool export development --format=json --output=exporter

Another solution - migrate to snake case

Hello,
What version of Postgre do you use?
What Operating System do you use?

It might fix the problem 363d02a

@antifree

we use for reproduce bug

  • Latest stable EntityFramework and latest stable NPGSQL
  • ASP.NET 3.x - BlazorServer - development enviroment - Windows 10 Pro
  • PosgterSQL 12.1 Alpine in Docker

@silverbulleters-github-service
Hello,

we have already published v.1.4.1.

Yes - new release fix the problem

Thanks, thanks, thanks

изображение