Why aren't BEFORE rules allowed to do inserts, updates or deletes?
Is there a good reason?
Martin Bowes

I have a jdbc application which maintanes a connection to a database.
Every morning, the application fires up and runs a set of queries using
this long standing connection.
To generate a set of reports the application  runs the same sets of

I love query auditing, it can really show exactly which query - or
sequence of queries - is producing errors!
And in this case we see this little beauty:
drop table a_table;

,
I am using jaxtr, and if you also sign up, we can talk for free on the phone at any time.  
-Vijay  
P.S. Here is the link to sign up:

I have a question about PMget and the configuration file format.
In the Wiki :  http://community.ingres.com/wiki/Ingres_CL_PM
it is said that :
Value String     Any number of concatenated "Undelimited Value Strings"

The videos from osbootcamp7 are online. The theme for this event was
Eclipse. The videos include a talk by Jo Peel about the Ingres DTP
plugin. You can view them here:
http://www.osbootcamp.org/index.php?page=osbc7

I have an interesting problem that I'd like people to try out so I can
see how generic it is...I think its pretty generic.
I have found this:
*         On II 9.1.1 (a64.lnx/103)NPTL + patch12978, patch12819.

The Ingres 2.6 Command Reference Guide's description for the usermod command states "The usermod command modifies a database's user-defined tables to the most appropriate storage structure for accelerating query processing."
I had thought that usermod simply modified the tables to ...

I want to migrate some stored functions from oracle to ingres.
If i am not wrong, I must create a procedure in ingres which returns the
value that was returned by oracle function.
The problem is that I haven't found a way to get this value.

How much does a view remember about the columns involved in its
definition?
I'd always thought next to nothing as a the view definition was stored
as a text unit and not as a compiled expression....

Does it require the ingres net and associated technolgy to use
the .net provider, like ODBC does?  Thanks.

Hi,  Is there any practical difference between a 'long varchar' column
compared to a 'long byte' column field?
Long varchar seems to accept binary data without problem.    We are just
storing and then retriving the data,  the column will not appear in any

For about the 200th time I've just had someone ask me if there's a way an
ABF application can tell if a session global temporary table already (or
still) exists.  It's an old chestnut and I always feel a twinge when I give
the bad news.

One of my colleagues is dealing with a Unicenter Helpdesk site and has a
call open with CA (remember them?).  The problem is that he's noticed
that when a query includes a LIKE condition where the pattern contains
no wild-card characters but the pattern is longer than the declared

i am using ingres 2006 under centos 5.0
i have to migrate from oracle to ingres,
i have a huge amount of data , about 50 G
but the default ingres configuration seem not to work for me