Обсуждение: Using always genereted

Поиск
Список
Период
Сортировка

Using always genereted

От
Łukasz Jarych
Дата:
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 

Re: Using always genereted

От
Guillaume Lelarge
Дата:
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_history
 alter 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.

Re: Using always genereted

От
Łukasz Jarych
Дата:
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_history
 alter 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.

Re: Using always genereted

От
Łukasz Jarych
Дата:
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,
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_history
 alter 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.