Subject | Re: [firebird-support] Re: Firebird 3: Not able to UPDATE RDB$Procedures |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2018-05-31T16:22:43Z |
31.05.2018 18:14, blackfalconsoftware@... [firebird-support] wrote:
SQL> show version;
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird 3.0"
on disk structure version 12.0
SQL> create procedure aaaaaa as begin /* */ end;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';
RDB$PROCEDURE_SOURCE
====================
1a:1e0
==============================================================================
RDB$PROCEDURE_SOURCE:
begin /* */ end
==============================================================================
SQL> update rdb$procedures set rdb$procedure_source=null where rdb$procedure_name='AAAAAA';
SQL> commit;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';
RDB$PROCEDURE_SOURCE
====================
<null>
--
WBR, SD.
> However, maybe Firebird 3.x.x does NOT allow this as Carlos' manual suggests...I've just trued:
SQL> show version;
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird 3.0"
on disk structure version 12.0
SQL> create procedure aaaaaa as begin /* */ end;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';
RDB$PROCEDURE_SOURCE
====================
1a:1e0
==============================================================================
RDB$PROCEDURE_SOURCE:
begin /* */ end
==============================================================================
SQL> update rdb$procedures set rdb$procedure_source=null where rdb$procedure_name='AAAAAA';
SQL> commit;
SQL> select rdb$procedure_source from rdb$procedures where rdb$procedure_name='AAAAAA';
RDB$PROCEDURE_SOURCE
====================
<null>
--
WBR, SD.