On 06/11/15 19:21, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
> Still, I'm bemused as to why you want to fiddle with the constraints
> if you're not changing them.
Well, to give some rough data; with constraints, my test case takes 10
mins to import, without, 4 mins (that
Hello Scott,
Saturday, November 7, 2015, 4:01:48 AM, you wrote:
> I have a feeling that the answer is 'no', but...
> In a FB2.5 system is there a way to temporarily disable foreign key
> constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Constraints and their indexes, no. A constraint
I have a feeling that the answer is 'no', but...
In a FB2.5 system is there a way to temporarily disable foreign key
constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Got a big lump of clean data I want to drop into a table.
Alternatively, how safe is dropping/recreating the FKs on
Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote:
> In a FB2.5 system is there a way to temporarily disable foreign key
> constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Well, here is the way to activate indexes and foreign keys:
How to activate all indexes?
On 06/11/15 16:15, Rik van Kekem r...@graficalc.nl [firebird-support] wrote:
> Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote:
>> In a FB2.5 system is there a way to temporarily disable foreign key
>> constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
> Well, here is the way
Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote:
> You can't inactivate a FK constraint:
B.T.W. This is a (still open) feature request:
http://tracker.firebirdsql.org/browse/CORE-1924