Postgres wrong data type/s

[aetasoul]

Hi,
I'm using Postgresql as database, the tables were manually generated.

• PG version: 14.1-1.pgdg110+1
• NHibernate version: 5.3.10
• FluentNHibernate version: 3.1.0
• Npgsql version: 6.0.2

------- TABLE AUTHOR -------
CREATE TABLE author (
	id bigint NOT NULL,
	name character varying(50)
);
ALTER TABLE author OWNER TO myuser;

CREATE SEQUENCE author_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
ALTER TABLE author_id_seq OWNER TO myuser;
ALTER SEQUENCE author_id_seq OWNED BY author.id;
ALTER TABLE ONLY author ALTER COLUMN id SET DEFAULT nextval('author_id_seq'::regclass);
ALTER TABLE ONLY author ADD CONSTRAINT author_pkey PRIMARY KEY (id);

------- TABLE BOOK -------
CREATE TABLE book (
	id bigint NOT NULL,
	author_id bigint NOT NULL,
	title character varying(100)
);
ALTER TABLE book OWNER TO myuser;

CREATE SEQUENCE book_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
ALTER TABLE book_id_seq OWNER TO myuser;
ALTER SEQUENCE book_id_seq OWNED BY book.id;
ALTER TABLE ONLY book ALTER COLUMN id SET DEFAULT nextval('book_id_seq'::regclass);
ALTER TABLE ONLY book ADD CONSTRAINT fko5rb7l9pwc20t4465iphn69wt FOREIGN KEY (author_id) REFERENCES author(id);
ALTER TABLE ONLY book ADD CONSTRAINT book_pkey PRIMARY KEY (id);

Classes

public class AuthorClass
{
	public virtual long Id { get; protected set; }
	public IList<BookClass> Books { get; set; }
	public virtual string Name { get; set; }
}

public class BookClass
{
	public virtual long Id { get; protected set; }
	public AuthorClass Author { get; set; }
	public virtual string Title { get; set; }
}

Mappings

public class AuthorMap : ClassMap<AuthorClass>
{
	public AuthorMap()
	{
		Table("author");

		Id(x => x.Id).Column("id").CustomSqlType("bigint").GeneratedBy.SequenceIdentity("author_id_seq");
		Map(x => x.Name).Column("name").CustomSqlType("character varying(50)");
	}
}

public class BookMap : ClassMap<BookClass>
{
	public BookMap()
	{
		Table("book");

		Id(x => x.Id).Column("id").CustomSqlType("bigint").GeneratedBy.SequenceIdentity("book_id_seq");
		References(x => x.Author).Column("author_id").Cascade.All().Not.Nullable();
		Map(x => x.Title).Column("title").CustomSqlType("character varying(100)");
	}
}

Code

ISessionFactory _sessionFactory = Fluently.Configure()
.Database(PostgreSQLConfiguration.Standard.ConnectionString("Server=localhost;Port=5432;Database=MyDatabase;User Id=myuser;Password=mypassword;"))
.Mappings(m => m.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly()))
.ExposeConfiguration(config =>
{
  SchemaValidator schemaValidator = new SchemaValidator(config);
  schemaValidator.Validate();
})
.BuildSessionFactory();

The schema validation generate an Exception, checking the ValidationErrors array:

- ValidationErrors	Count = 1	System.Collections.ObjectModel.ReadOnlyCollection<string>
    [0] "Wrong column type in MyDatabase.public.book for column author_id. Found: bigint, Expected int8" string

---

Changing the Mappings without .CustomSqlType:

public class AuthorMap : ClassMap<AuthorClass>
{
	public AuthorMap()
	{
		Table("author");

		Id(x => x.Id).Column("id").GeneratedBy.SequenceIdentity("author_id_seq");
		Map(x => x.Name).Column("name");
	}
}
	
public class BookMap : ClassMap<BookClass>
{
	public BookMap()
	{
		Table("book");

		Id(x => x.Id).Column("id").GeneratedBy.SequenceIdentity("book_id_seq");
		References(x => x.Author).Column("author_id").Cascade.All().Not.Nullable();
		Map(x => x.Title).Column("title");
	}
}

The schema validation generate an Exception for each data type, checking the ValidationErrors array:

-	ValidationErrors	Count = 5	System.Collections.ObjectModel.ReadOnlyCollection<string>
	[0]	"Wrong column type in MyDatabase.public.author for column id. Found: bigint, Expected int8"	string
	[1]	"Wrong column type in MyDatabase.public.author for column name. Found: character varying, Expected varchar(255)"	string
	[2]	"Wrong column type in MyDatabase.public.book for column id. Found: bigint, Expected int8"	string
	[3]	"Wrong column type in MyDatabase.public.book for column author_id. Found: bigint, Expected int8"	string
	[4]	"Wrong column type in MyDatabase.public.book for column title. Found: character varying, Expected varchar(255)"	string

---

Changing the version of the Npgsql to 4.1.10 all works correctly, would you fix this?

[fredericDelaporte]

Duplicate of #2876 or #1895, according to viewpoint.