Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Alex Peshkoff via Firebird-devel

On 1/26/22 17:48, Roman Simakov wrote:

I hope it can be handled while restoring. I have no good idea how to
deal with differences between 3 and 4. It's possible to make a gap in
5 and handle it while restoring as well.


Let's make a gap only when have real need to change it.




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Roman Simakov
I hope it can be handled while restoring. I have no good idea how to
deal with differences between 3 and 4. It's possible to make a gap in
5 and handle it while restoring as well.

ср, 26 янв. 2022 г. в 17:03, Jiří Činčura :
>
> > They are also reinserted without changes in backup/restore...
>
> Even better, not!
>
> This looks like a bug to me. Should I create an issue?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
>
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Роман Симаков


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Jiří Činčura
> They are also reinserted without changes in backup/restore...

Even better, not! 

This looks like a bug to me. Should I create an issue?

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Adriano dos Santos Fernandes
On 26/01/2022 10:38, Jiří Činčura wrote:
>> Perhaps we should have reserved several items but ...
> 
> Exactly. But. 
> 
> Given the value is easily accessible for everybody in system tables, it's a 
> WTF moment.
> 

They are also reinserted without changes in backup/restore...


Adriano


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Jiří Činčura
> Perhaps we should have reserved several items but ...

Exactly. But. 

Given the value is easily accessible for everybody in system tables, it's a WTF 
moment.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Roman Simakov
It's the first constant for DDL privileges and other constants must be
before it. See obj.h. Adding objects for DML privileges moved it
further.
Perhaps we should have reserved several items but ...
Maybe to leave a comment in code for the next move to make a gap?

ср, 26 янв. 2022 г. в 16:01, Jiří Činčura :
>
> Hi *,
>
> Is there a reason why the obj_database (and items following) changed values 
> between FB3 and FB4? This sucks a lot. Now when reading i.e. from 
> RDB$USER_PRIVILEGES.RDB$OBJECT_TYPE one has to distinguish between FB3 and 
> FB4 when handling what object it is.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Роман Симаков


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] obj_database value in FB3 and FB4

2022-01-26 Thread Jiří Činčura
Hi *,

Is there a reason why the obj_database (and items following) changed values 
between FB3 and FB4? This sucks a lot. Now when reading i.e. from 
RDB$USER_PRIVILEGES.RDB$OBJECT_TYPE one has to distinguish between FB3 and FB4 
when handling what object it is. 

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel