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

From Michael Glaesemann
Subject Re: create unique index schema.index_name on table (column)?
Date
Msg-id 386A2126-0480-11D9-9715-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: create unique index schema.index_name on table (column)?  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-sql
On Sep 12, 2004, at 2:48 PM, Michael Glaesemann wrote:

>
> On Sep 12, 2004, at 5:42 AM, m0ntar3@cox.net wrote:
>
>> Is the syntax "schema_name.index_name" for create unique index wrong, 
>> unsupported or what? I know is doesn't work as postgres kicks me back 
>> a syntax error each time (version 7.3.2 & 7.4.5). -sigh-
>
> Could you give a full example (including the error) of what you're 
> doing? It's kind of hard to give a suggestion based on your brief 
> description.

Also, looking quickly at the online docs, we find :

> name
>
> The name of the index to be created. No schema name can be included 
> here; the index is always created in the same schema as its parent 
> table.

<http://www.postgresql.org/docs/current/static/sql-createindex.html>

Michael



pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: create unique index schema.index_name on table (column)?
Next
From: Tom Lane
Date:
Subject: Re: create unique index schema.index_name on table (column)?