Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.2/8.9.1) with ESMTP id FAA19396 for ; Sat, 13 Mar 1999 05:25:22 -0500 (EST) (envelope-from nicolasb@maich.gr) Received: from zorbas.maich.gr (zorbas.maich.gr [193.218.36.66]) by trends.net (8.8.8/8.8.8) with SMTP id FAA09711 for ; Sat, 13 Mar 1999 05:13:52 -0500 (EST) Received: from Lasaracina ([195.120.255.25]) by zorbas.maich.gr (4.1/SMI-4.1) id AA01168; Sat, 13 Mar 99 11:47:28 +0200 Message-Id: <001b01be6d3a$112ac920$19ff78c3@Lasaracina.iamb> From: "Nicholas Boretos" To: "Michael Davis" , Subject: R: [INTERFACES] DefineIndex fails Date: Sat, 13 Mar 1999 11:12:50 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3110.3 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 A: 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