dbTalk Databases Forums  

[BUGS] BUG #1492: PostgreSQL ODBC error

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1492: PostgreSQL ODBC error in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rong Wang
 
Posts: n/a

Default [BUGS] BUG #1492: PostgreSQL ODBC error - 02-20-2005 , 11:58 PM







The following bug has been logged online:

Bug reference: 1492
Logged by: Rong Wang
Email address: rong (AT) ozdocs (DOT) com.au
PostgreSQL version: 8
Operating system: Windows 2003
Description: PostgreSQL ODBC error
Details:

ODBC having an open nature allows client application to query SQL Syntax
capabilities of the database. The ODBC CK (an aplication using ODBC)uses
this to make sure it generates the correct syntax. When creating indexes it
asks the database if schema names should be used. PostgreSQL indicates they
should be used. When we do this we get a syntax error.

The technical detail:

When calling SQLGetInfo with the SQL_SCHEMA_USAGE InfoType it returns a
value with the SQL_SU_INDEX_DEFINITION set. It looks like this should not be
set.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.