RE: [INTERFACES] DefineIndex fails

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: "'Nicholas Boretos'" <nicolasb(at)maich(dot)gr>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] DefineIndex fails
Date: 1999-03-13 19:03:15
Message-ID: 93C04F1F5173D211A27900105AA8FCFC14527F@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I have no idea what to check next.

-----Original Message-----
From: Nicholas Boretos [SMTP:nicolasb(at)maich(dot)gr]
Sent: Saturday, March 13, 1999 3:13 AM
To: Michael Davis; pgsql-interfaces(at)postgreSQL(dot)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(dot)davis(at)prevuenet(dot)com>
A: pgsql-interfaces(at)postgreSQL(dot)org <pgsql-interfaces(at)postgreSQL(dot)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(at)maich(dot)gr]
Sent: Friday, March 12, 1999 1:52 PM
To: pgsql-interfaces(at)postgreSQL(dot)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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ben Gunter 1999-03-14 03:22:57 Re: [INTERFACES] DefineIndex fails
Previous Message Tom Lane 1999-03-13 18:12:58 Re: [INTERFACES] [off-topic] Database normalization, can't be done!