You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Stanley Bradbury <St...@gmail.com> on 2006/08/01 15:59:29 UTC

Re: SQL-orders equivalent to Oracle?

sm@Bonn.IZ-Soz.de wrote:
> Hi,
>
>  Does Apache-Derby-embedded Version 10.1.3.1 have equivalents to the
> following Oracle statements? 
>     DISABLE CONSTRAINT ... 
>     ENABLE CONSTRAINT ...
>
>
> Thanks for answer in advance
>
> Kind regards
>
> Siegfried Schomisch
>
> ----------------------------------------
> Social Science Information Centre
> Department Research & Development
> Siegfried Schomisch, M.A. 
> Lennestr. 30, D-53113 Bonn, Germany
> Phone: (+49) 228 2281 168
> Fax: (+49) 228 2281 120 
> E-mail: sm@bonn.iz-soz.de
> http://www.gesis.org/IZ/  
> -----------------------------------
>
>   
Hi -

There is no way currently to temporarily disable constraints in Derby (I 
am guessing from the command wording that this is the functionality you 
are inquiring about).  I searched for a feature request in JIRA and 
found DERBY-532 (deferrable constraints) - Please review the request 
at:  http://issues.apache.org/jira/browse/DERBY-532  to see if this 
addresses your need.  If not, please file a feature request so this need 
comes to the attention of the Developer community.

HTH