Using always genereted

Started by Łukasz Jarychover 7 years ago4 messagesgeneral
Jump to latest
#1Ł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?

Best,
Jacek

#2Guillaume Lelarge
guillaume@lelarge.info
In reply to: Łukasz Jarych (#1)
Re: Using always genereted

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.

#3Łukasz Jarych
jaryszek@gmail.com
In reply to: Guillaume Lelarge (#2)
Re: Using always genereted

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):

Show quoted text

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.

#4Łukasz Jarych
jaryszek@gmail.com
In reply to: Łukasz Jarych (#3)
Re: Using always genereted

Sorry,

my error.

pt., 13 lip 2018 o 09:52 Łukasz Jarych <jaryszek@gmail.com> napisał(a):

Show quoted text

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.