<<< 21.12.2016 9:34 - Helen Borrie helebor@... [firebird-support] "firebird-support@yahoogroups.com" >>>
HBhinafs> Hello Roland,
HBhinafs>
HBhinafs> Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote:
HBhinafs>

>> But I cannot call this:

HBhinafs>

>> update RDB$GENERATORS set rdb$generator_increment = 1 where
>> rdb$generator_name not starting 'RDB$';

HBhinafs>
HBhinafs> System Tables are read-only in Fb 3.
HBhinafs>

>> how can I set the value to 1?

HBhinafs>
HBhinafs> Read the release notes, page 71 (pdf page 81) and all will be
HBhinafs> revealed. (On-line:
HBhinafs>
HBhinafs> http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-altersequence
HBhinafs>
HBhinafs> HB

Thanks Helen, I haven't known that this DDL command exists in that
form to manipulate it.

But still, why this problem occurred? Why didn't some generators have
it =1?

--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk