[Info-ingres] dbmsinfo()

[Roy Hann]

Thursday, November 17, 2016, 3:20:11 PM, you wrote:

> As an idea for an extension to the wonderful dbmsinfo()….
>  
> dbmsinfo(‘lock_level’); --- which would respond with one of page, table, row, mvcc
> dbmsinfo(‘readlock’); --- which would respond with one of nolock, shared, exclusive

This is information I have wanted to get but I don't think dbmsinfo()
currently lends itself to the problem. One can have different lock
levels for the session and for any number of specified tables. Ditto
readlock modes.

You'd have to radically enhance the way dbmsinfo request names are
specified. You'd also have to make them case-sensitive to correctly
deal with case-sensitive installations.

That's not to say radically enhancing dbmsinfo() is a bad idea.

Roy Hann
Rational Commerce Ltd.
T +44 20 8691 2089
"Ingres development, tuning and training experts"