If it is a primary key then it will automatically be UNIQUE.
You do not need the unique next to the VARCHAR in this situation
Darren
On Thu, 14 Feb 2002, Erwin Ambrosch wrote:
> Hi,
>
> I have a such a table.
>
> CREATE TABLE int_article (
> name VARCHAR(12) UNIQUE
> headline TEXT,
> summary TEXT,
> main TEXT,
> footer TEXT,
> PRIMARY KEY (name)
> );
>
> Is the UNIQUE constraint neccessary, because if have specified the column
> name to be the primary key.
>
> Thanks in advance
> Erwin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>