From: | Blake McBride <blake(at)mcbride(dot)name> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, pgsql-odbc(at)postgresql(dot)org |
Subject: | SQLStatistics problem |
Date: | 2006-08-23 20:04:35 |
Message-ID: | 7.0.1.0.2.20060823145234.0255e7e0@mcbride.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Greetings,
I am having a problem with SQLStatistics. I am using Hiroshi Inoue's
latest ODBC DLL's, PostgreSQL 8.1.2, all on Windows XP.
I issued the following SQL statements:
ALTER TABLE ONLY rights
ADD CONSTRAINT rights_id_key UNIQUE (id);
CREATE UNIQUE INDEX blake ON rights (deny_flag);
When I do a dump of the database the two statements create different
results as I would expect. By "different results" I mean the dump uses
different commands to re-create each of those things. One is a constraint
and the other an index.
When I use ODBC SQLStatistics I get back records for each of those statements
but there is no way to distinguish the constraint from the index.
Any help would be appreciated.
Sincerely,
Blake McBride
blake(at)mcbride(dot)name
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2006-08-23 20:19:05 | Re: ADO and sequences |
Previous Message | João Eduardo Maciel Neto | 2006-08-23 14:39:10 | what unregister of group ? |