Re: primary key and unique index

2018-03-24 Thread Thomas Poty
e-mail in error, please inform us immediately on +44 (0)1963 370511 > and delete it and all copies from your system. > > > > *Thales UK Limited. A company registered in England and Wales. Registered > Office: 350 Longwater Avenue, Green Park, Reading, RG2 6GF. Registered >

RE: primary key and unique index

2018-03-24 Thread HORDER Phil
gmail.com] Sent: 23 March 2018 07:56 To: pgsql-general@lists.postgresql.org Subject: primary key and unique index Hi all, I am migrating fromMySQL to Postgresql 9.6. In MySQL a "show create table" gives me : ... PRIMARY KEY (`ID`,`CountryCode`,`LanguageCode`), UNIQUE KEY `uniq

Re: primary key and unique index

2018-03-23 Thread Achilleas Mantzios
On 23/03/2018 09:55, Thomas Poty wrote: Hi all, I am migrating fromMySQL to Postgresql 9.6. In MySQL a  "show create table" gives me :  ...   PRIMARY KEY (`ID`,`CountryCode`,`LanguageCode`),   UNIQUE KEY `unique_my table_4` (`ID`,`CountryCode`,`LanguageCode`), ... So, In PostgreSQL, does it ma

Re: primary key and unique index

2018-03-23 Thread David Rowley
On 23 March 2018 at 20:55, Thomas Poty wrote: > In MySQL a "show create table" gives me : > ... > PRIMARY KEY (`ID`,`CountryCode`,`LanguageCode`), > UNIQUE KEY `unique_my table_4` (`ID`,`CountryCode`,`LanguageCode`), > ... > > So, In PostgreSQL, does it make sense to create a primary key AND

primary key and unique index

2018-03-23 Thread Thomas Poty
Hi all, I am migrating fromMySQL to Postgresql 9.6. In MySQL a "show create table" gives me : ... PRIMARY KEY (`ID`,`CountryCode`,`LanguageCode`), UNIQUE KEY `unique_my table_4` (`ID`,`CountryCode`,`LanguageCode`), ... So, In PostgreSQL, does it make sense to create a primary key AND a uni