Re: Scheme conversion MySQL to PGSQL - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Scheme conversion MySQL to PGSQL
Date
Msg-id 40A1A9E2-75C6-4CDB-A786-402D03962CD0@gmail.com
Whole thread Raw
In response to Scheme conversion MySQL to PGSQL  ("Michelle Konzack" <linux4michelle@tamay-dogan.net>)
List pgsql-general
> On 24 Dec 2017, at 18:52, Michelle Konzack <linux4michelle@tamay-dogan.net> wrote:

> CREATE TABLE sqmf_stat (
>      stat_login        varchar(70)     NOT NULL,
>      stat_post         integer         default '1',
>      stat_thread       integer         default '1',
>      PRIMARY KEY       (stat_login),
>      UNIQUE KEY user   (stat_login)
> );

Just a minor observation, but a PRIMARY KEY is UNIQUE by definition. There's no need for that UNIQUE key "user" on the
samefield. 

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.



pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Array of foreign key
Next
From: "Michelle Konzack"
Date:
Subject: [OT] subscribtion with no-mail option?