Hi Thomas,

Using your recommended Query

Before GBak backup/restore

RDB$DEPENDENT_TYPE RDB$DEPENDED_ON_TYPE COUNT
2 0
169
2 5
3
2 7
32
2 14
12
2 15
6
5 0
583
5 5
23
5 7
4
5 14
26
5 15
44
5 17
1

After GBak backup/restore

RDB$DEPENDENT_TYPE RDB$DEPENDED_ON_TYPE COUNT
2 0
169
2 5
3

GBak backup/restore is done every month since the database is so
stable, never had a single problem from FB 0.9 till FB 2.1

Since there is no DML created on the 'fly', only when I change or
add something to the tables , procedures or triggers, I'm wondering
from the above query results where the extra rows come from and
it looks like deleting them is safe. Looking for an explanation of
the values for the RDB$DEPENDENT_TYPE and RDB$DEPENDED_ON_TYPE

Best Regards
Hans

----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, December 18, 2008 12:22 AM
Subject: Re: [firebird-support] RDB$DEPENDENCIES row entries with
RDB$FIELD_NAME = NULL


> Hello Hans,
>
>> My database been operational without flaws for last 12 years since FB
>> 1.x,
>> I have no views :)
>
> The following statement will give a stastic of dependencies without a
> field name involved:
>
> select
> rdb$dependent_type
> , rdb$depended_on_type
> , count(*)
> from
> rdb$dependencies
> where
> rdb$field_name is null
> group by
> rdb$dependent_type
> , rdb$depended_on_type
>
>
> With the result set, we might be able to point you to dependencies where
> a field name is not involved.
>
> It does not need to be view, e.g. do you have stored procedures or
> triggers referencing a generator? Just an example. ;-)
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
> My blog:
> http://blog.upscene.com/thomas/
>
>
>
>> ----- Original Message -----
>> From: "Thomas Steinmaurer" <ts@...>
>> To: <firebird-support@yahoogroups.com>
>> Sent: Wednesday, December 17, 2008 11:32 PM
>> Subject: Re: [firebird-support] RDB$DEPENDENCIES row entries with
>> RDB$FIELD_NAME = NULL
>>
>>
>>>> I just noticed numerous row entries
>>>> in RDB$DEPENDENCIES with RDB$FIELD_NAME = NULL
>>>>
>>>> Now using FB2.1, but it looks like they where created already
>>>> in earlier versions.
>>>>
>>>> Can I just delete these entries, or do they serve a purpose ?
>>> They do. For example a view is dependent on a table. Or a procedure is
>>> dependent on a table ...
>>>
>>> --
>>> Best Regards,
>>> Thomas Steinmaurer
>>> LogManager Series - Logging/Auditing Suites supporting
>>> InterBase, Firebird, Advantage Database, MS SQL Server and
>>> NexusDB V2
>>> Upscene Productions
>>> http://www.upscene.com
>>> My blog:
>>> http://blog.upscene.com/thomas/
>>>
>>> ------------------------------------
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>>
>>> Visit http://www.firebirdsql.org and click the Resources item
>>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>>
>>> Also search the knowledgebases at http://www.ibphoenix.com
>>>
>>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> Visit http://www.firebirdsql.org and click the Resources item
>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>> Also search the knowledgebases at http://www.ibphoenix.com
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> Yahoo! Groups Links
>>
>>
>>
>>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>