Re: [Firebird-devel] How an RDB$ index can be rebuilt in 3.0

[Pavel Zotov]

From: Pavel Cisar <pci...@ibphoenix.cz>
Subject: Re: [Firebird-devel] How an RDB$ index can be rebuilt in 3.0
===
An RDB$INDEX_* is typically an automatically created one for constraint.
So you have to identify the constraint, drop it and then recreate it.
===

In 3.0 and above no such ability:

SQL> show version;
ISQL Version: WI-T4.0.0.197 Firebird 4.0 Unstable
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-T4.0.0.197 Firebird 4.0 Unstable"
Firebird/Windows/Intel/i386 (remote server), version "WI-T4.0.0.197 Firebird 4.0 Unstable/tcp (csprog)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-T4.0.0.197 Firebird 4.0 Unstable/tcp (csprog)/P13"
on disk structure version 12.0
SQL>

 

SQL> alter table rdb$user_privileges add constraint rdb$up_123 unique(rdb$index_id);
Statement failed, SQLSTATE = 28000
unsuccessful metadata update
-ALTER TABLE RDB$USER_PRIVILEGES failed
-no permission for ALTER access to TABLE RDB$USER_PRIVILEGES

------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel