Re: auto generated primary keys

2017-05-20 Thread pieter gmail
Hi, Yes that is it thanks. I was reading 2.1.0 as that's the docker I installed. Don't see Identity Column mentioned there. I'll try to install 2.2.0. Is it correct then to define a auto increment primary key as, |CREATE TABLE identity_employee ( id LARGEINT GENERATED ALWAYS AS IDENTITY, des

RE: auto generated primary keys

2017-05-20 Thread Eric Owhadi
Hi Pieter, Did you look at section 5.11 Identity Column? Is it what you are looking for? Regards, Eric -Original Message- From: pieter gmail [mailto:pieter.mar...@gmail.com] Sent: Saturday, May 20, 2017 12:41 PM To: user@trafodion.incubator.apache.org Subject: RE: auto generated primary k

RE: auto generated primary keys

2017-05-20 Thread Anoop Sharma
hi, trafodion supports identity columns that can be used to auto-generate primary keys. Details are in SQL Reference manual http://trafodion.apache.org/docs/sql_reference/index.html#identity_column There is also support for implicit SYSKEY column which is used to automatically generate a uniq

RE: auto generated primary keys

2017-05-20 Thread pieter gmail
Hi, Does/will trafodion support auto generated primary keys? I can not see any mention of it in the docs. Thanks Pieter

RE: docker

2017-05-20 Thread pieter gmail
Hi, Are there plans for a docker image for version 2.1.0? Thanks Pieter