Anyone else see this article from a couple of weeks ago?
http://www.computerweekly.com/Articles/2006/02/14/214165/Opensourcedatab
ase'yearsawayfrombeingaseriouscontender'.htm
I was wondering whether Ingres Corp had contacted Gartner to mention

After ALTER TABLE ADD COLUMN we encountered the following error when
executing UPDATE t1 FROM t2 type of query.
The error only dissapeared after recreating rules on table t1.
Does that mean we  need to recreate the rules every time we execute the

Is their some trick to getting PHP to work with Ingres.  I get this:
Warning: ingres_connect() [function.ingres-connect]: Ingres error :
790536 : Unable to authenticate client's user ID. in
/usr/local/apache2/htdocs/index.php on line 42

The system is True64 5.1b -3 patch kit 5
6Gb mem and 4 cpu.
And Ingres II 2.6/0305 (axp.osf/00)   Patch 9882
We have a big problem with our system, when there are have heavy load on the

       In case of sequence in ingres, is there any command available to
set the value of the sequence to some value.
For e.g.  Lets sequence name is "mysequence"
Then in case of postgresql we can set the value of a sequence to say

I have a table that was created like this:
create table missaskh(
    artnr varchar(15),
    kdnr varchar(10),

       There is ingres envionment variable II_GCNII_LCL_VNODE.
When we install ingres, II_GCNII_LCL_VNODE gets the vaule as host name
of the machine on which installation is done.
If suppose we change the hostname of the machine somewhere after ingres

Following a disk upgrade  on a WinXPproSP2 system, the drive letters shifted
and my Ingres installation is now on E: rather than the D: drive.   Apart
from the letter name, drive E: is exactly the same as what D: used to be
before the upgrade.

I have a query shown below.  When I give specific dates for
'start_report_month_ty' and 'end_report_month_ty', it runs in about 2
minutes.
If I ask it to look the dates up from the single row table

      I am having a scenario in which I have to take the data backup
(and not the schema backup) of the database and again restore it back.
Database is having tables and some sequences.
I am using copydb command to take the backup of the database as follows:

       I am using ingres sql command to execute the sql commands
(create/insert/delete),
While executing ingres 'sql' command, all the errors that raises gets
displayed on standard

-----Original Message-----
From: users-bounces+pwhite=peerlessit.com.au@ingres.ca.com [mailto:users-bounces+pwhite=peerlessit.com.au@ingres.ca.com] On Behalf Of Ronald Jeninga
Sent: Monday, 20 February 2006 6:51 PM
To: users@ingres.ca.com

We changed the work lkocation of a database by adding the new location
in Accessdb. The old location is no longer needed but when we try to
delete the old one we get the message that we can't delete it because it
is still in use by a database. The only problem is that we aren't

It's easy to tell that the new Ingres Corp has people working on winning
mind-share.  The news items are coming thick and fast even when Ingres isn't
the focus of the story.  Here's another:
http://news.ft.com/cms/s/94ca75b0-9e5f-11da-b641-0000779e2340.html