Thread: patch for PGAPI_Columns with Show system tables turned on

Hello,

  when I take a look at VB6 and RowCount (again) and I turn Parse
Statement option on there is problem with SQLColAttribute for
select * from pg_class. I found that pg_* is forbidden in PGAPI_Columns
when Show system tables is turned off. I think it's not right behaviour.

I write small patch which changes this behaviour. When is pg_* asked
in PGAPI_Columns directly it doesn't matter if Show system tables is
turned on or off.

Please review and comment

Luf

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org on behalf of Ludek Finstrle
Sent: Sat 12/17/2005 11:42 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] patch for PGAPI_Columns with Show system tables turned on

> when I take a look at VB6 and RowCount (again) and I turn Parse
> Statement option on there is problem with SQLColAttribute for
> select * from pg_class. I found that pg_* is forbidden in PGAPI_Columns
> when Show system tables is turned off. I think it's not right behaviour.

Hmm. I can see arguments for either side, but I think I agree with you - we should allow it if the app requests a
specifictable (or matching wildcard). 

Regards, Dave.