From: Nicholas Boretos <nicolasb@maich.gr>
To: Ben Gunter <bgunter@alef.gcsu.edu>
To: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: R: [INTERFACES] DefineIndex fails
Date: Mon, 15 Mar 1999 10:20:39 +0100
Message-ID: <002001be6ec5$23c6db00$19ff78c3@Lasaracina.iamb> (raw)
Thanx for suggestions,
I was able to resolve this by changing table and field names all to lower
case letters.
In psql, on a linux box I would get the relation to capitoli not found
whether I typed "Capitoli" of "capitoli" for the table name. Seems that psql
does not differentiate between caps and lower case. Same for field names.
The only thingI can think of is that I load an Italian keyboard map?
Anyway, we sahall continue like this for now.
Thanx to all:-)
Nicolas Boretos
-----Messaggio originale-----
Da: Ben Gunter <bgunter@alef.gcsu.edu>
A: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Data: domenica 14 marzo 1999 4.02
Oggetto: Re: [INTERFACES] DefineIndex fails
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
>
>
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-interfaces@postgresql.org
Cc: nicolasb@maich.gr, bgunter@alef.gcsu.edu
Subject: Re: R: [INTERFACES] DefineIndex fails
In-Reply-To: <002001be6ec5$23c6db00$19ff78c3@Lasaracina.iamb>
* 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