Received: from mail.alltel.net (mail.alltel.net [166.102.165.30])
	by hub.org (8.9.2/8.9.1) with ESMTP id WAA01890
	for <pgsql-interfaces@postgresql.org>;
	Sat, 13 Mar 1999 22:23:24 -0500 (EST)
	(envelope-from bgunter@alef.gcsu.edu)
Received: from alef.gcsu.edu (miga2pp86.alltel.net [166.102.104.87])
	by mail.alltel.net (8.9.3/ALLTEL Messaging Service) with ESMTP id
	VAA15188 for <pgsql-interfaces@postgresql.org>;
	Sat, 13 Mar 1999 21:23:16 -0600 (CST)
Sender: bgunter@mail.alltel.net
Message-ID: <36EB2B91.E432F0DF@alef.gcsu.edu>
Date: Sat, 13 Mar 1999 22:22:57 -0500
From: Ben Gunter <bgunter@alef.gcsu.edu>
X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.2.3 i586)
MIME-Version: 1.0
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] DefineIndex fails
References: <93C04F1F5173D211A27900105AA8FCFC14527F@lambic.prevuenet.com>
	<36EB2AE5.1CF530C0@alef.gcsu.edu>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Ben Gunter wrote:

This may sound like an assinine suggestion, but stranger things have
happened...  Are you sure you're connecting to database you think you're
connecting to?  Are you typing this in at the psql prompt or doing it
some other way?  Can you show us a pg_dump of the database schema?

-Ben

Michael Davis wrote:
>
> I have no idea what to check next.
>
>         -----Original Message-----
>         From:   Nicholas Boretos [SMTP:nicolasb@maich.gr]
>         Sent:   Saturday, March 13, 1999 3:13 AM
>         To:     Michael Davis; pgsql-interfaces@postgreSQL.org
>         Subject:        R: [INTERFACES] DefineIndex fails
>
>         Thank you,
>         The spelling is correct and the tables exist; just checked again.
> Anything
>         else I should check?
>         Sincerely,
>         Nicolas Boretos
>         -----Messaggio originale-----
>         Da: Michael Davis <michael.davis@prevuenet.com>
>         A: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
>         Data: venerd́ 12 marzo 1999 22.46
>         Oggetto: RE: [INTERFACES] DefineIndex fails
>
>         The spelling and/or case of the table name used in the create index
>         statement.  Make sure the table exists in your Postgres database.
>
>         -----Original Message-----
>         From: Nicholas Boretos [SMTP:nicolasb@maich.gr]
>         Sent: Friday, March 12, 1999 1:52 PM
>         To: pgsql-interfaces@postgreSQL.org
>         Subject: [INTERFACES] DefineIndex fails
>
>         Hello,
>         Managed to figure out my read-only problem using ODBC with Access,
>         and import tables with data. Trying to recreate the keys with
>         CREATE UNIQUE INDEX idx ON table (field)
>
>         fails with DefineIndex: table relation not found.
>         Any clues?
>         tia,
>         Nicolas Boretos
>
>