'Andrew Zenz' and...@aimsoftware.com.au [firebird-support] wrote:
> FYI FirstAID scanned the database and identified 2 tables as having
> corruption. I attempted a data pump with DBW excluding those 2 tables
> but it failed on several other tables, tables that FirstAID claims are
> clean.
The
On 29/03/16 11:44, Małgorzata Barchańska go...@fastdata.com.pl
[firebird-support] wrote:
> I'm very curious - so what makes our database file so big? Sum of clear
> metadata
> and raw data is about 2,4GB, and what with other 12GB? Is anything we
> can do to shrink our big database file (drop
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?
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
Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote:
> is it possible to restore a database without constraints? Or is there
> another way to do this? I just want do delete each primary key in the db.
Is this on a healthy DB? I'm not sure if -I disables the constraints in
that case.
On 21/08/15 14:17, 'Bogdan' bog...@mordicom.si [firebird-support] wrote:
order by iif(:i = 1, t.c, IIF(:I = 0, sum(t.a) - sum(t.b), E))
DESCENDING
If i run it with i = 0 it gives wrong sort order.
SUMA A B C D E
-1,11,2