Description:
Issues relating to INGRES products.
|
|
|
Incremental rollforward
|
| |
Hello all, I'm trying to rollforward incrementally from an old checkpoint because I'm missing checkpoint 6. This command is rejected rollforwarddb mydb \#c5 +c -j -incremental -norollback with error Mon Nov 16 15:39:25 2009 E_DM1373_RFP_INCR_ARG Invalid argument(s) #c for incremental rollforwarddb.... more »
|
|
|
Heads up re Ingres 9.3
|
| |
I am on-site with a customer who has run into a rather serious issue upgrading to Ingres Datbase 9.3 that neither they nor I was aware of. As it is a bit of a show-stopper, some of you may want to know about it. Buried in the release notes it says, "Ingres 9.3 is a limited release targeted at *new application development* [emphasis added by me] on... more »
|
|
|
Clearing the complete flag
|
| |
Apart from hacking the scomplete flag in iistatistics is there a "respectable" way to clear the complete flag on an attribute?
|
|
|
Problem with info-ingres hopefully resolved
|
| |
Gang, There have been some problems with info-ingres the last few days. Turns out my "upstream" provider expanded their cluster and I had improperly specified an ACL. Hopefully, this is resolved. Please let me know personally if you see any more issues. Cheers, Michael Leo Kettle River Consulting M...@KettleRiverConsulting.com... more »
|
|
|
Open Source Adoption Survey
|
| |
Hi everyone, The 451 Group is conducting an open source adoption survey. We’d like to ensure that the views of the Ingres community are represented. Please take a moment to complete this survey, and forward the link to anyone else who can offer insight into the benefits of open source adoption and... more »
|
|
|
Using gdb with the ABF library
|
| |
I am looking at a problem with an ABF application that is being ported to 9.2/9.3 x86 64-bit Linux. There seems to be a problem with a couple of SELECT-loops which looks like the number of pre-fetched rows is somehow being messed up so that sometimes a bogus extra row is returned and other times too few rows are returned.... more »
|
|
|
opf_hash_join set on by default at Ingres 9.2 - for a fresh install
|
| |
Ingres 9.2 with a new install sets opf_hash_join ON but if you upgrade the installation from Ingres 2.6 this setting is left off. Presumable to avoid problems with some existing queries. I assume that set on is going to help efficiency sometimes - does anyone know about this? Interesting that if I hadn't... more »
|
|
|
char() + char() AND NOT IN vs outer join
|
| |
Hi All, The following query runs in 7 hours: insert into lab_result( sample_id, test_id, result, when_analysed, status, participant_id, visit_id ) select sample_id, test_id, result, when_analysed, status, participant_id, visit_id from session.temp_lab_result where char(sample_id) +'-' +char(test_id) not in(select char(sample_id)... more »
|
|
|
|
