Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

2019-03-13 Thread Rashid Abzalov
13.03.2019 18:07, Alex Peshkoff via Firebird-devel пишет: Pre-FB3 versions made it possible to modify system tables directly including creation of new triggers on them. Currently such triggers are restored from 2.5 backup and can't be removed afterwards. I suggest to skip such triggers during r

Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

2019-03-13 Thread Alex Peshkoff via Firebird-devel
On 3/13/19 6:26 PM, liviuslivius wrote: I do not have this to test but can such trigger be altered and then droped? In 2.5 yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

2019-03-13 Thread Dmitry Yemanov
13.03.2019 18:07, Alex Peshkoff via Firebird-devel wrote: Pre-FB3 versions made it possible to modify system tables directly including creation of new triggers on them. Currently such triggers are restored from 2.5 backup and can't be removed afterwards. I suggest to skip such triggers during

Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

2019-03-13 Thread liviuslivius
I do not have this to test butcan such trigger be altered and then droped?Regards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Upgrading from 2.5 database with trigger on system table

2019-03-13 Thread Alex Peshkoff via Firebird-devel
Pre-FB3 versions made it possible to modify system tables directly including creation of new triggers on them. Currently such triggers are restored from 2.5 backup and can't be removed afterwards. I suggest to skip such triggers during restore with appropriate warning. Opinions? Firebird-De