Devart Forums

Hi,

since Postgres 10 there is an option to create an column as IDENTITY. Postgres creates an internal sequence which cannot be dropped.

see https://www.postgresql.org/docs/12/sql-createtable.html

The problem is that the unidac components are not aware of this option an so the IsAutoIncrement in the FieldDesc is false.

To get this information you have to look in the pg_attributte catalog an look if attidentity is not an empty char.
see https://www.postgresql.org/docs/10/cata ... ibute.html

Please implement this as soon as possible.

Greetings
Manuel Bursch

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Hello,

will you fix this issue for your next release?

Hello,
We'll support IDENTITY fields in one of the next releases.

wbr, Oleg
Devart Team

Hello,

is this feature already implemented?

Hi There,
No yet, this functionality is still on process of development

Regards,
Evgeniy

Hi,

any news for this?

Best regards,
Manuel

Kindly be informed that we have changed the FieldDesc.IsAutoIncrement to True for the GENERATED ALWAYS AS IDENTITY fields.
This fix will be added in the next build of our product and will be available to all customers. Please note that as a workaround until a new build is released, we may provide you with a UniDAC nightly build that includes this solution. To create this assembly for you, please provide us with your license number and the IDE version you are interested in.