UUID default values for new column

Saurabh
Contributor

Hello,

We would like to generate UUID values in a new column for rows that are being inserted into a table. The default values documentation suggests that we cannot use functions or expressions other than current_user and current_date/timestamp. In addition to that, Exasol does not support triggers.

Is there a way to accomplish this?

Thanks

1 ACCEPTED SOLUTION

Saurabh
Contributor

The solution did help, but we decided to take another route using:

https://docs.exasol.com/sql/merge.htm

View solution in original post

3 REPLIES 3

Saurabh
Contributor

The solution did help, but we decided to take another route using:

https://docs.exasol.com/sql/merge.htm

View solution in original post

exa-MathiasHo
Community Manager
Community Manager

Hi @Saurabh,

Do you have an update here? Did the solution of @mwellbro help?

 

Best regards,
Mathias

mwellbro
Xpert

Hi Saurabh,

using an IDENTITY column ( https://docs.exasol.com/sql_references/data_types/identitycolumns.htm?Highlight=identity ) is not an option ?

Cheers,
Malte