Skip site navigation (1) Skip section navigation (2)

Re: create unique index schema.index_name on table (column)?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: m0ntar3(at)cox(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: create unique index schema.index_name on table (column)?
Date: 2004-09-12 05:55:22
Message-ID: 12899.1094968522@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
m0ntar3(at)cox(dot)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

In response to

pgsql-sql by date

Next:From: mØntar3Date: 2004-09-12 20:33:38
Subject: Re: create unique index schema.index_name on table (column)?
Previous:From: Michael GlaesemannDate: 2004-09-12 05:54:33
Subject: Re: create unique index schema.index_name on table (column)?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group