If I have a rule on an update of a table which updates a column in the
same table it causes a cascade of updates to the same table.
How can I work around the cascade problem ?
Is there any syntax which I can put into the stored proc. triggered by

Hello Gus,
I have a little problem here creating a checkpoint for a database as a
user different from the "ingres" user.
Things that happened:

   I get this error when trying to add a column using ALTER TABLE...
The Error is...
E_QE009D Alter Table ADD/DROP column support for pages greater than 2k
   only.

I've been trying to run OpenROAD 3.5 images against OpenROAD 4.1 and
OpenROAD 2006 runtime on AIX 5.3, without any luck. Following the
suggestion shown in the errormessage ("Upgrade to a higher level") is
currently no option. Has anybody ever managed to run OR 3.5 images against

Trying to make our Ingres 2.6 / OpenROAD 4.1 application be able to run on
DB2 through Ingres's gateway
One of the many problems has been UPDATE FROMs
I have a routine that parses the UPDATE FROM statement and converts it into

On a new icebreaker installation, in ISQL, I get the following message:
__ Thu Feb 21 10:52:52 2008 ___________________________________________________
  1>      UPDATE  act_trans_enc a FROM enctrans_view b
             SET add_descr = LEFT(b.add_descr,30)

David,
It's been a while since I did this also, and I did it for C on VMS, but it should be somewhat similar.
In II_SYSTEM:[ingres.files] there should be a com file that ABF uses to build your app.
You will need to compile your Fortran routine with the /debug option - I seem to ...

Just a quick FYI. I've been taunted by Roy into making a new soundex
function for Ingres. The existing function is based on the Knuth
implementation of the Russell soundex (circa 1918!). I'm proposing an
implementation of the Daitch-Mokotoff soundex (circa 1980). Which means

We use real old timers ingres.
We still have an abf application on VMS.
We have a bug in a frame which calls an embedded fortran routine.
I need to debug the fortran routine.

Article about it
http://www.regdeveloper.co.uk/2008/02/18/stonebraker_dbms_outdated/
Paper -
http://www.vldb.org/conf/2007/papers/industrial/p1150-stonebraker.pdf

We are on a vax vms 6.4 release of Ingres from which we run batch jobs
over ingres net
The databases are Ingres 2.6 on an alpha running HPUX
the following statement will not compile with esqlf

If anyone from the UK (and perhaps elsewhere in Europe) is considering
attending the Ingres Engineering Summit (April 21-25,
http://www.ingres.com/events/engineering-summit-2008.php), you may be
interested to know that a bit of shopping around can dramatically reduce the

can someone tell me please, preferably by a pointer to a web site, when
Ingres
was first made available on Linux ?  I can't find historic release dates
on ingres.com

Follow up. 10 seconds googling found dial a flight.com, with:
Best Priced Flight Fare to Dominican Republic
Our Best Flight Fare from HEATHROW to PUNTA CANA is from £299 + £218 tax  
(Total £517) leaving on 19 April 2008, and returning from Punta Cana on 26

does anyone know where I could find an Ingres 9.0.4 non-RPM
Installer?
(Or do you know how to install the RPM Version in Debian? Alienating
does not work.)