Thread: Using always genereted
hi,
i am trying to alter table :
ALTER TABLE logging.t_history
alter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
but this is not working. Error i have.
How to change this properly?
Best,
Jacek
Hi,
--
2018-07-13 9:29 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:
hi,i am trying to alter table :ALTER TABLE logging.t_historyalter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,but this is not working. Error i have.How to change this properly?
Which error message do you get?
--
Guillaume.
Hi,
thank you.
I think that i have to add sequance here...
Best,
Jacek
pt., 13 lip 2018 o 09:50 Guillaume Lelarge <guillaume@lelarge.info> napisał(a):
Hi,2018-07-13 9:29 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:hi,i am trying to alter table :ALTER TABLE logging.t_historyalter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,but this is not working. Error i have.How to change this properly?Which error message do you get?
--Guillaume.
Sorry,
my error.
pt., 13 lip 2018 o 09:52 Łukasz Jarych <jaryszek@gmail.com> napisał(a):
Hi,thank you.I think that i have to add sequance here...Best,Jacekpt., 13 lip 2018 o 09:50 Guillaume Lelarge <guillaume@lelarge.info> napisał(a):Hi,2018-07-13 9:29 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:hi,i am trying to alter table :ALTER TABLE logging.t_historyalter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,but this is not working. Error i have.How to change this properly?Which error message do you get?
--Guillaume.