Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user
Date
Msg-id 4681A8CC.1020706@tpf.co.jp
Whole thread Raw
In response to Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user  (Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk>)
Responses Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user  (Dave Page <dpage@postgresql.org>)
Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user  (Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk>)
Re: Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user  (Andreas <maps.on@gmx.net>)
List pgsql-odbc
Mark Cave-Ayland wrote:
> On Wed, 2007-06-20 at 23:47 +0900, Hiroshi Inoue wrote:
>
>> Recently added boolean options are defined as some bits in Extra Opts.
>> Is it OK to define the option as a bit in Extra Opts ?
>
> Inoue-san,

Hi Mark,
Sorry for the late answer.

> Thanks for your feedback. I've had a look at the code for Extra Options
> (and thought a bit more about it), and I'd prefer to keep the option as
> a separate tick-box if possible.

There are already so many options and I'm not eager to increase
the options excessively. It's also pretty painful to add a check
box etc in the setup dialog. Basically I want to use bits in the
Extra Opts for boolean options herafter.

> My reason for this is that the people
> who want this feature are the people who want to get rid of extra tables
> they see over ODBC. Generally these people have already found the "Hide
> System Tables" option but can't work out how to remove the extra tables,
> so for me it makes sense to put the two options close to each other.
> Also, for support purposes, it would be much easier to explain a tick
> box over the phone rather than get them to read out the "Extra Options",
> calculate the new value and then type it back in as a hex value!

How about changing the default behavior of SQLTables to list only
SELECTable tables and add a bit to Extra Opts to list inaccessible
tables also ?

regards,
HIroshi Inoue


pgsql-odbc by date:

Previous
From: Richard Wesley
Date:
Subject: Re: Using the PostgreSQL ODBC driver for another database
Next
From: Hiroshi Inoue
Date:
Subject: Re: Why is UseDeclareFetch so slow?