Postgres Pro
Downloads
Home   >   mailing lists

Re: create unique index schema.index_name on table (column)? - Mailing list pgsql-sql

From Tom Lane
Subject Re: create unique index schema.index_name on table (column)?
Date
Msg-id 12899.1094968522@sss.pgh.pa.us
Whole thread Raw
In response to create unique index schema.index_name on table (column)?  (m0ntar3@cox.net)
List pgsql-sql
Tree view 
m0ntar3@cox.net writes:
> Is the syntax "schema_name.index_name" for create unique index wrong, 
> unsupported or what?

Yes.

Put the schema name on the table, instead.
        regards, tom lane

pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: create unique index schema.index_name on table (column)?
Next
From: "Smit"
Date:
Subject: what is maximum size of "text" datatype in postgres?