#1 2023-02-13 07:30:50

dcoun
Member
From: Crete, Greece
Registered: 2020-02-18
Posts: 392

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: ctid column name is reserved for postgres

Offline

#3 2023-02-13 08:32:35

dcoun
Member
From: Crete, Greece
Registered: 2020-02-18
Posts: 392

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

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

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

Board footer

Powered by FluxBB