From: mØntar3 <m0ntar3@cox.net>
To: Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: create unique index schema.index_name on table (column)?
Date: Sun, 12 Sep 2004 15:33:38 -0500
Message-ID: <4144B2A2.2070506@cox.net> (raw)
In-Reply-To: <64E33C90-047F-11D9-9715-000A95C88220@myrealbox.com>
References: <8rJ0d.57642$nk.2844@okepread05>
<64E33C90-047F-11D9-9715-000A95C88220@myrealbox.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: m0ntar3@cox.net, grzm@myrealbox.com
Subject: Re: create unique index schema.index_name on table (column)?
In-Reply-To: <4144B2A2.2070506@cox.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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