pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedDefineIndex fails
4+ messages / 3 participants
[nested] [flat]
* DefineIndex fails
@ 1999-03-12 20:52 Nicholas Boretos <nicolasb@maich.gr>
0 siblings, 0 replies; 4+ messages in thread
From: Nicholas Boretos @ 1999-03-12 20:52 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] DefineIndex fails
@ 1999-03-12 22:08 Michael Davis <michael.davis@prevuenet.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Davis @ 1999-03-12 22:08 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] DefineIndex fails
@ 1999-03-13 19:03 Michael Davis <michael.davis@prevuenet.com>
1999-03-14 03:22 ` Re: [INTERFACES] DefineIndex fails Ben Gunter <bgunter@alef.gcsu.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Davis @ 1999-03-13 19:03 UTC (permalink / raw)
To: 'Nicholas Boretos' <nicolasb@maich.gr>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] DefineIndex fails
1999-03-13 19:03 RE: [INTERFACES] DefineIndex fails Michael Davis <michael.davis@prevuenet.com>
@ 1999-03-14 03:22 ` Ben Gunter <bgunter@alef.gcsu.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Ben Gunter @ 1999-03-14 03:22 UTC (permalink / raw)
To: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-03-14 03:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-12 20:52 DefineIndex fails Nicholas Boretos <nicolasb@maich.gr>
1999-03-12 22:08 RE: [INTERFACES] DefineIndex fails Michael Davis <michael.davis@prevuenet.com>
1999-03-13 19:03 RE: [INTERFACES] DefineIndex fails Michael Davis <michael.davis@prevuenet.com>
1999-03-14 03:22 ` Ben Gunter <bgunter@alef.gcsu.edu>
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