From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
---|---|
To: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
Cc: | m0ntar3(at)cox(dot)net, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: create unique index schema.index_name on table (column)? |
Date: | 2004-09-12 05:54:33 |
Message-ID: | 386A2126-0480-11D9-9715-000A95C88220@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Sep 12, 2004, at 2:48 PM, Michael Glaesemann wrote:
>
> On Sep 12, 2004, at 5:42 AM, m0ntar3(at)cox(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-09-12 05:55:22 | Re: create unique index schema.index_name on table (column)? |
Previous Message | Michael Glaesemann | 2004-09-12 05:48:38 | Re: create unique index schema.index_name on table (column)? |