From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Blake McBride <blake(at)mcbride(dot)name> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: SQLStatistics problem |
Date: | 2006-08-24 13:22:50 |
Message-ID: | 44EDA82A.5060906@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Blake McBride wrote:
>
> 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.
One way seems to be to check the existence of pg_constraint data
whose name = the index_name.
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-08-24 15:25:39 | [ psqlodbc-Bugs-1000709 ] SQLForeignKeys missing FK_NAME missing PK_NAME |
Previous Message | Hiroshi Inoue | 2006-08-24 01:11:56 | Re: ADO and sequences |