Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Production DB. RDB$RELATION_FIELDS.RDB$UPDATE_FLAG is 0, expect 1

46 views
Skip to first unread message

Pieter Bas Hofstede

unread,
Sep 24, 2024, 4:49:43 AM9/24/24
to firebird-support
Hi all,

I've got a production database where for one particular table the RDB$RELATION_FIELDS.RDB$UPDATE_FLAG for all fields is 0. But all fields are 'regular' fields so I expect it to have a value of 1.

All works ok, but some functionality check this 'UPDATE_FLAG' to determine if this field is computed or writable.
Any idea how to fix this database?

Thanks in advance

Pieter Bas Hofstede

unread,
Sep 25, 2024, 2:41:21 AM9/25/24
to firebird-support
As solution for my functional problem I can join RDB$FIELDS and check if RDB$COMPUTED_BLR has a value to determine the field is computed or not.

But.. do I need to repair this database for the 'wrong' RDB$UPDATE_FLAG values (will start using replication in near future)? 

On FB4.0.4.3010, but problem may even been introduced in a FB3.x version because backup/restore doesnt repair it.

Op dinsdag 24 september 2024 om 10:49:43 UTC+2 schreef Pieter Bas Hofstede:

Dimitry Sibiryakov

unread,
Sep 25, 2024, 5:15:29 AM9/25/24
to firebird...@googlegroups.com
Pieter Bas Hofstede wrote 25.09.2024 8:41:
> But.. do I need to repair this database for the 'wrong' RDB$UPDATE_FLAG values
> (will start using replication in near future)?

Firebird itself doesn't use this field at all.

--
WBR, SD.

Pieter Bas Hofstede

unread,
Sep 25, 2024, 5:25:59 AM9/25/24
to firebird-support
Thanks, I'll ignore the values and use a different solution.

Op woensdag 25 september 2024 om 11:15:29 UTC+2 schreef sd:
Reply all
Reply to author
Forward
0 new messages