To qualify that concern, I do not care that much about doing any FNH generated database migrations, only for the basic ORM tasks, structuring appropriate queries, joins, etc, projections and models and such. So dialect-wise, would there need to be any pg updates?
On Tuesday, June 3, 2025 at 3:57:34 PM UTC-4 Michael W Powell wrote: > Question, is there anything more recent > than PostgreSQLConfiguration.PostgreSQL83, is that for what, pg 8.3?! Will > that be sufficient?! Right now ATM we are talking about at least pg 16+, > which I have installed presently. > > On Tuesday, June 3, 2025 at 12:27:47 PM UTC-4 Michael W Powell wrote: > >> Hello, >> >> I am reviewing pg, NodaTime, and FNH docs, for mappings supporting >> Duration, Instant, probably couple of others, but those are the major ones. >> >> As far as I know, Duration maps to pg interval. Generally analog to >> dotnet TimeSpan. >> >> What is the NH analog for pg timestamp? Generally analoy of dotnet >> DateTime, DateTimeOffset. Databases are usually created with data types >> TIMESTAMP WITH TIME ZONE clauses. >> >> In terms of NH PrimitiveType Instant what should we be doing for >> PrimitiveClass and ReturnedClass? There are no comments there, so it is >> difficult to say. Best guess is types of TimeSpan and Duration, >> respectively; or DateTimeOffset and Instant, respectively. Or DateTime, >> perhaps, rather than DateTimeOffset. >> >> Then how do I teach NH (FNH) how to treat those types at a fundamental >> level? Or do the maps, types, etc, all get magically reflected into FNH? >> >> >> https://nhibernate.info/blog/2011/01/26/date-time-support-in-nhibernate.html >> https://postgresql.org/docs/current/datatype-datetime.html >> >> As well as comparison with efcore. >> >> >> https://npgsql.org/efcore/mapping/nodatime.html?tabs=ef9-with-connection-string >> >> Best, >> >> Michael W. Powell >> >> -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/fluent-nhibernate/c4b64a04-5252-41d7-949d-8d50329b4b26n%40googlegroups.com.
