Re: [firebird-support] Re: Differences when adding a Primary Key

2015-08-22 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Nobody knows the answer? Well, then I shall add this to the "Firebird's mysteries". Greetings. Walter. On Fri, Aug 21, 2015 at 4:47 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Hello Ann > > Well, the world has not falled out, nothing so dangerous, the error > me

Re: [firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
Alright, so the remaining questions to someone with that knowledge are: - Does the problem going from 2.5.1 to 2.5.4 still only concern compound indices containing at least one NULLable (VAR)CHAR and no other indices than that? If not, what else? - Is the following code enough to rebuild a sup

Re: [firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
That's very interesting! Does this behavior still exist? Is there any way to verify that? So basically, if I execute the following after moving from 2.5.1 to 2.5.4 I should be fine? SET TERM !! ; EXECUTE BLOCK AS DECLARE VARIABLE stmt VARCHAR(1000); BEGIN for select 'ALTER INDEX '||rdb$index_

Re: [firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

[firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
I thought 2.5.2 behaves the same as 2.5.1 but now I'm running into sources that say that even 2.5.2 requires action when coming from a 2.5.1 database. Is the old info still actual that I only need those constraints that are both compound and have at least one (VAR)CHAR in them without 'NOT NULL'

[firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
All those constraints are a dependency hell. Are there any significant downsides to just using 2.5.2 for a year with the 2.5.1 database, considering 2.5.1 was working fine for me, and all I need more is the additional service_mgr functionality of making remote backups? Then in a year I can do a

[firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
Damn, if I'd need to recreate most of my primary keys, that is going to be a major pain... I found a query to activate all indices but isn't there a way to deactivate them all in the right order to achieve the right effect?

Re: [firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread setysvar setys...@gmail.com [firebird-support]
Den 22.08.2015 15:26, skrev Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]: > 22.08.2015 16:06, tvd...@ymail.com wrote: > >> Rebuilding the indices is not the issue. It's just that the warning >> implies that rebuilding the whole database is really better than just >> rebuilding th

[firebird-support] Re: 2.5.1 upgrade dilemma

2015-08-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.08.2015 16:06, tvd...@ymail.com wrote: > Rebuilding the indices is not the issue. It's just that the warning > implies that rebuilding the whole database is really better than just > rebuilding the indices. Am I still at any kind of risk if I just rebuild > the indices? What is the worst thing

[firebird-support] 2.5.1 upgrade dilemma

2015-08-22 Thread tvd...@ymail.com [firebird-support]
I have several hundreds of Firebird installations out there that use 2.5.1. Because of features added in 2.5.2 I updated my setup to install the latest version, 2.5.4. Now, after a small amount of those installations have been updated, I noticed the warning in 3.5.3: "Warning re Databases Crea