Thread: RE: [INTERFACES] DefineIndex fails

RE: [INTERFACES] DefineIndex fails

From
Michael Davis
Date:
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