Skip to content

Category Archives: ingres

List of Ingres functions per release

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 [...]

What BLOB tables do I have?

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 [...]

UK IUA 2010 Call for Papers Now Open

It’s that time of the year again – the call for papers for the UK IUA June conference:
UK Ingres User Association Conference 2010
10th June 2010, London
www.iua.org.uk
Outlines or abstracts for presentations on Ingres, OpenROAD, open source, or any other Ingres-related topics are welcome. The theme for this year’s event is “Open Source Innovation” so any [...]

Best Facebook Updates ever.

See and download the full gallery on posterous

Posted via email from Idle thoughts

Curso de Administración de BBDD Ingres – Madrid 14 de Diciembre

Nos complace anunciarles el próximo curso de Administración de Bases de Datos Ingres (Managing Ingres Installations and Databases – Ingres DBM), que dará comienzo el día 14 de diciembre en Madrid.
Este curso tiene una duración de 5 días, y permitirá, obtener los conocimientos necesarios para:

Crear, configurar y monitorizar su instalación Ingres
Entender las tareas vitales que [...]

The SQL Guide to Ingres – Available via Amazon

I’ve been very remiss in not mentioning this before but there is now an Ingres book available!?!! I’ve not yet bought a copy (but will do the next time I am in the UK) and can not review it. Until I do get my hands on a copy the following is a description of the [...]

Ingres PHP support for HP OpenVMS CSWS 2.0

For those of you who are interested in running PHP on OpenVMS with Ingres, I have published a pre-built binary to
http://esd.ingres.com/product/drivers/PHP/HP_OpenVMS_Alpha/PHP_Driver. Installation instructions are available via http://bit.ly/InstallPHPIngresOpenVMS or in the README.VMS file contained within the download. The supplied PHP_INGRES.EXE has been built against Ingres 9.2.0 (axm.vms/143). If you want this extension for a different version [...]

Community Wiki Syntax Highlighting

I have written an article in the Ingres Community Wiki on how you can use syntax highlighting to make your code samples easier to read and download. Hop on over to http://community.ingres.com/wiki/Wiki_Syntax_Highlighting for information on how you can turn:

— Ingres
— SQL to create the base schema for MediaWiki
— set autocommit on;
CREATE [...]

PHP Ingres 2.2.1 released

The last release of the PHP driver introduced a regression where by the “EXECUTE PROCEDURE” or “CALL” SQL statements would fail to execute (PECL bug 16688). The bug slipped through the net due to missing tests for database procedures. This oversight has now been resolved and the fix has been rolled into a new release, [...]

PHP Ingres 2.2.0 released

My record for monthly releases came to a grinding halt in March and for a good reason. At some point between December and February I introduced a series of regressions in to the driver code causing memory leaks and segmentation violations. I hope these have now all been fixed and as you can see from [...]