(Postgres) GENERATED AS IDENTITY
(Postgres) GENERATED AS IDENTITY
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
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
Re: (Postgres) GENERATED AS IDENTITY
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
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
Re: (Postgres) GENERATED AS IDENTITY
Hello,
will you fix this issue for your next release?
will you fix this issue for your next release?
Re: (Postgres) GENERATED AS IDENTITY
Hello,
We'll support IDENTITY fields in one of the next releases.
wbr, Oleg
Devart Team
We'll support IDENTITY fields in one of the next releases.
wbr, Oleg
Devart Team
Re: (Postgres) GENERATED AS IDENTITY
Hello,
is this feature already implemented?
is this feature already implemented?
Re: (Postgres) GENERATED AS IDENTITY
Hi There,
No yet, this functionality is still on process of development
Regards,
Evgeniy
No yet, this functionality is still on process of development
Regards,
Evgeniy
Re: (Postgres) GENERATED AS IDENTITY
Hi,
any news for this?
Best regards,
Manuel
any news for this?
Best regards,
Manuel
Re: (Postgres) GENERATED AS IDENTITY
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.
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.