SQLStatistics problem

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

Responses

Browse pgsql-odbc by date

  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 ?