(Postgres) GENERATED AS IDENTITY

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bursch
Posts: 20
Joined: Tue 25 Sep 2018 07:45

(Postgres) GENERATED AS IDENTITY

Post by bursch » Thu 26 Nov 2020 09:03

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

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: (Postgres) GENERATED AS IDENTITY

Post by oleg0k » Thu 03 Dec 2020 17:39

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

bursch
Posts: 20
Joined: Tue 25 Sep 2018 07:45

Re: (Postgres) GENERATED AS IDENTITY

Post by bursch » Thu 18 Feb 2021 15:17

Hello,

will you fix this issue for your next release?

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: (Postgres) GENERATED AS IDENTITY

Post by oleg0k » Tue 16 Mar 2021 13:52

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

wbr, Oleg
Devart Team

bursch
Posts: 20
Joined: Tue 25 Sep 2018 07:45

Re: (Postgres) GENERATED AS IDENTITY

Post by bursch » Wed 28 Jul 2021 13:47

Hello,

is this feature already implemented?

evgeniym
Devart Team
Posts: 103
Joined: Thu 13 May 2021 07:08

Re: (Postgres) GENERATED AS IDENTITY

Post by evgeniym » Thu 29 Jul 2021 08:51

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

Regards,
Evgeniy

bursch
Posts: 20
Joined: Tue 25 Sep 2018 07:45

Re: (Postgres) GENERATED AS IDENTITY

Post by bursch » Wed 08 Dec 2021 12:36

Hi,

any news for this?

Best regards,
Manuel

evgeniym
Devart Team
Posts: 103
Joined: Thu 13 May 2021 07:08

Re: (Postgres) GENERATED AS IDENTITY

Post by evgeniym » Mon 13 Dec 2021 05:46

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.

Post Reply