Open VladislavRybnikov opened 10 months ago
Hello there!
We hope you are doing well. We noticed that this issue has not seen any activity in the past 90 days. We consider this issue to be stale and will be closing it within the next seven days.
If you still require assistance with this issue, please feel free to reopen it or create a new issue.
Thank you for your understanding and cooperation.
Best regards, EventFlow
Hi!
I am using PostgreSQL read models and discovered an issue with the column names.
STR
ConfigurePostgreSql
andUsePostgreSqlReadModel
[PostgreSqlReadModelIdentityColumn]
attribute to ReadModel's propertyId
AR When working with read models I am receiving an error from PostgreSQL that column
id
does not existsER Should work well with such configuration by default OR should be configured by registering custom
ReadModelSqlGenerator
:But even registration of this custom
ReadModelSqlGenerator
does not help, because probably there is a bug in ReadModelSqlGenerator. https://github.com/eventflow/EventFlow/blob/cf4287b4de914cba07c9a85f43228dba6a8908a6/Source/EventFlow.Sql/ReadModels/ReadModelSqlGenerator.cs#L105 - on this line prefix and suffix - not used at all, so probably it is a bug, because they are used here - https://github.com/eventflow/EventFlow/blob/cf4287b4de914cba07c9a85f43228dba6a8908a6/Source/EventFlow.Sql/ReadModels/ReadModelSqlGenerator.cs#L149 .Also, there is a question, why
columnQuotedIdentifierPrefix: "\""
andcolumnQuotedIdentifierSuffix: "\""
- not used by default for PostgreSql configuration?