I have always told people that the only way to turn off strict SQL-92
compliance is to de-install and re-install Ingres. But is that true?

Assuming there are no database objects that rely on case-sensitivity to
be distinguishable, is it feasible to just turn it off in config.dat?

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

On Jan 29, 2010, at 8:02 AM, Roy Hann wrote:

You can certainly change the various config.dat options: the id-case
settings, the flattening settings, and whatever else the compliance
option might affect. What you can't easily fix are all the catalog
table, view, and column names which have been created in
uppercase thanks to the reg_id_case being set to upper by strict
compliance. The server itself usually if not always references
catalogs by table ID number, rather than name, so most things
should continue to work.

I ran into a database accidently created under strict compliance
some years back, and my recollection is that just enough "stuff"
didn't work to cause serious annoyance. I don't recall what
exactly did or didn't work, though.

Karl

I had a support issue on this a few years ago. I can't remember all the
details but I recall that there were a number of iterations of finding
the next problem, fixing it and so on until the customer decided it was
less effort to re-install.

I do remember it's more than just switching it off in config.dat.

HTH
Paul

Paul Mason wrote:

Thank you Paul and Karl. I will take that as, "You are quite right
Roy". :-)

Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Even sql92 compliance could be turned off, should you have already
created a database system catalogs will reflect this.
For example all table and index names etc are then in upper case.
Thus may open the door for further headaches. Then verifydb and maybe
other utilities would not expect having upper/lower object names.

Yes reinstalling of Ingres is the only solution here!


--
bilgihan

Yes I remember looking at / working on a customer site about 12 years
ago where they decided to enable SQL 92 compliance to see what it would
do and use the new facilities it introduced (their words not
mine)………..

Their fix at the time rather than reinstalling Ingres etc was to set to
OFF the SQL 92 related config.dat settings plus hack the catalogues, to
this day they still have weird problems with the databases in this
installation because of their fix especially when upgrading the Ingres
version.

Cheers, David


--
quida01

Ingres Forums wrote:

That made me laugh out loud. :-) :-)

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.