As noted elsewhere this week saw the relaunch of the Ingres documentation site http://docs.ingres.com. At last we have the ability to deep link into the documentation without having to do acrobatics to extract links in the docs, for example http://docs.ingres.com/Ingres/9.3/Database%20Administrator%20Guide/largedataloadswsetnologgingstatement.htm has become http://docs.ingres.com/ingres/9.3/database-administrator-guide/1757-large-data-loads-with-the-set-nologging-statement To get the URL for the first required some navigation of the [...]
Wednesday, August 4, 2010
Over the last couple of days I’ve done couple of Ingres installations using the latest, bleeding edge, RPMs and have come across a change in behaviour that might catch you out, as indeed it did me. What follows is a more or less verbatim copy of the output from an install of the latest SVN [...]
Also filed in
|
|
(Picked up from the forums). Ingres are broadcasting live webinars for Ingres VectorWise, starting this week. The first is entitled ‘Welcome to Ingres VectorWise” Join our Ingres System Engineers as they share a high-level overview of the Ingres VectorWise technology including a demonstration of the product. Find out more about this new feature and to [...]
Thanks to Andrew Ross and FOSSLC, the Ingres VectorWise demo from this year’s UK IUA conference can be seen below or via Vimeo.com (Flash is required).
History what? For some time the Ingres terminal monitor has had the, slightly cryptic (to me at least), flag “-history_recall”. This flag allows you to use the cursor keys within a terminal monitor session to scroll through previous queries and edit them in-line. Users of Ingres on Windows have been able to do this by [...]
For new users to Ingres quitting from the Ingres terminal monitor, tm or sql, just got easier. With change 2901 the terminal monitor has gone from this: $ sql iidbdb INGRES TERMINAL MONITOR Copyright 2010 Ingres Corporation Ingres Linux Version II 10.0.0 (int.lnx/2863)NPTL login Thu Apr 29 08:46:38 2010 continue * to: $ sql iidbdb [...]
Wednesday, April 14, 2010
Ingres’s OpenAPI C interface can be challenging at times especially when it comes to debugging or reading an API trace. For example, right now I’m trying to debug a problem in the PHP driver for Ingres. For some reason during the tear-down of the request the driver is unable to close a statement. Turning to [...]
Wednesday, April 14, 2010
Introduction Getting web applications to connect to Ingres via Apache on UNIX/Linux can be quite fiddly. Here is a simple guide on the setup steps needed to allow the Ingres PHP, Python and Ruby drivers to work with Apache on RedHat Enterprise Linux, CentOS and Fedora Linux. I’ve also published articles on doing the same [...]
Thursday, February 25, 2010
Yesterday Ray Fan published an article that shows IMA queries that allow you to see the list of functions available for different Ingres releases. I’ve now taken these queries an generated a list of functions for Ingres 9.2.0 with the added functions for 9.3.0 and 10.0.0 (a recentish build). I’ve not looked at earlier releases [...]
Tuesday, February 23, 2010
The following is SQL code was published in the #ingres IRC channel on freenode in response to a question about the best method to determine which iietab_xx_yy table belongs to which table: select r1.relid as base_table, c.attname as column_name, r2.relid as extend_table from iirelation r1,iirelation r2,iiattribute c,iiextended_relation e where r1.reltid=e.etab_base and r2.reltid=e.etab_extension and r1.reltid=c.attrelid and [...]
Ingres Newsgroup