DBMD supportsIntegrityEnhancementFacility() - should this return true?

From: Alex Winawer <postgresql(at)winawer(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DBMD supportsIntegrityEnhancementFacility() - should this return true?
Date: 2003-06-09 12:41:58
Message-ID: 200306091341.59252.postgresql@winawer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

My first question is does anyone know exactly what the "Integrity Enhancement
Facility" is? I can only find references to the description of method in the
JDBC Javadoc which isn't helpful ("Retrieves whether this database supports
the SQL Integrity Enhancement Facility.").

I am working on a project in which supportsIntegrityEnhancementFacility() is
being used to determine if the database supports ON DELETE CASCADE. Is this
the appropriate method for this and if so, should the PostgreSQL version be
changed to return true.

Current Implementation in AbstractJdbc1DatabaseMetaData.java is
/*
* Is the SQL Integrity Enhancement Facility supported?
* I haven't seen this mentioned anywhere, so I guess not
*
* @return true if so
* @exception SQLException if a database access error occurs
*/
public boolean supportsIntegrityEnhancementFacility() throws SQLException
{
if (Driver.logDebug)
Driver.debug("supportsIntegrityEnhancementFacility false ");
return false;
}

TIA
Alex Winawer

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message rcastagnoli@katamail.com 2003-06-09 13:03:04 Authentication problems
Previous Message Barry Lind 2003-06-08 15:53:45 Re: Official JDBC driver release ?