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

Re: SQLStatistics problem

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





In response to

pgsql-odbc by date

Next:From: noreplyDate: 2006-08-24 15:25:39
Subject: [ psqlodbc-Bugs-1000709 ] SQLForeignKeys missing FK_NAME missing PK_NAME
Previous:From: Hiroshi InoueDate: 2006-08-24 01:11:56
Subject: Re: ADO and sequences

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