Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: AndreasDate: 2006-08-23 20:19:05
Subject: Re: ADO and sequences
Previous:From: João Eduardo Maciel NetoDate: 2006-08-23 14:39:10
Subject: what unregister of group ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group