You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 2023-02-13 07:30:50
- dcoun
- Member
- From: Crete, Greece
- Registered: 2020-02-18
- Posts: 430
ctid column name is reserved for postgres
please add ctid to the reserved column names when using TSqlDBPostgresConnectionProperties
it can not be used as a property in an Orm definition
Offline
#2 2023-02-13 08:20:51
Re: ctid column name is reserved for postgres
Please check https://github.com/synopse/mORMot2/commit/4591ff70
Offline
#3 2023-02-13 08:32:35
- dcoun
- Member
- From: Crete, Greece
- Registered: 2020-02-18
- Posts: 430
Re: ctid column name is reserved for postgres
Thanks a lot @ab. Please fix also the RawJson type for FireDac.
I am using RawJson in case I want a Json Array orm property not to be a BloB file in the database with setter/getter and DynarrayJSONLoad/save
Offline
#4 2023-02-13 09:29:52
Re: ctid column name is reserved for postgres
A RawUtf8 field would be stored a TEXT field, i.e. as a limit-less text clob field, in PostgreSQL anyway.
From the ORM point of view, RawJson is handled as ftUtf8 / oftUtf8Text so it should use a TEXT field.
See https://github.com/synopse/mORMot2/commit/518702f4
I don't have FireDAC installed, so could you please see why you found a ftNull kind of field instead?
Offline
Pages: 1