pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcreate unique index schema.index_name on table (column)?
5+ messages / 4 participants
[nested] [flat]
* create unique index schema.index_name on table (column)?
@ 2004-09-11 20:42 m0ntar3@cox.net
0 siblings, 2 replies; 5+ messages in thread
From: m0ntar3@cox.net @ 2004-09-11 20:42 UTC (permalink / raw)
To: pgsql-sql
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-
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: create unique index schema.index_name on table (column)?
@ 2004-09-12 05:48 Michael Glaesemann <grzm@myrealbox.com>
parent: m0ntar3@cox.net
1 sibling, 2 replies; 5+ messages in thread
From: Michael Glaesemann @ 2004-09-12 05:48 UTC (permalink / raw)
To: m0ntar3@cox.net; +Cc: pgsql-sql
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.
Michael
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: create unique index schema.index_name on table (column)?
@ 2004-09-12 05:54 Michael Glaesemann <grzm@myrealbox.com>
parent: Michael Glaesemann <grzm@myrealbox.com>
1 sibling, 0 replies; 5+ messages in thread
From: Michael Glaesemann @ 2004-09-12 05:54 UTC (permalink / raw)
To: Michael Glaesemann <grzm@myrealbox.com>; +Cc: m0ntar3@cox.net; 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: create unique index schema.index_name on table (column)?
@ 2004-09-12 05:55 Tom Lane <tgl@sss.pgh.pa.us>
parent: m0ntar3@cox.net
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-09-12 05:55 UTC (permalink / raw)
To: m0ntar3@cox.net; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: create unique index schema.index_name on table (column)?
@ 2004-09-12 20:33 mØntar3 <m0ntar3@cox.net>
parent: Michael Glaesemann <grzm@myrealbox.com>
1 sibling, 0 replies; 5+ messages in thread
From: mØntar3 @ 2004-09-12 20:33 UTC (permalink / raw)
To: Michael Glaesemann <grzm@myrealbox.com>; +Cc: pgsql-sql
I'm working with a closed source application that reads an ASCII file
and as it does it (via ODBC) creates tables and indexes, inserting as it
goes. Like so:
CREATE TABLE bgsuser.CAXCTRLD ( CTRLS INTEGER, INTVL INTEGER);
CREATE UNIQUE INDEX bgsuser.PRIMARY_CAXCTRLD ON bgsuser.CAXCTRLD
(CTRLS,INTVL);
INSERT ...
INSERT ...
The application is designed to work through ODBC and psqlODBC does a
great job. My problem is the username (schema qualifier) on the create
index statement. I've decided it's easiest to copy/paste/modify the
create statements from the ODBC trace logs.. oh, well.
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.
>
> Michael
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-09-12 20:33 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-11 20:42 create unique index schema.index_name on table (column)? m0ntar3@cox.net
2004-09-12 05:48 ` Michael Glaesemann <grzm@myrealbox.com>
2004-09-12 05:54 ` Michael Glaesemann <grzm@myrealbox.com>
2004-09-12 20:33 ` mØntar3 <m0ntar3@cox.net>
2004-09-12 05:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox