Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
> So it doesn't seem that there is any option. Seems so. I just wanted confirmation from CORE guys, I didn't missed something. -- 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] Changing generator's initial value without restarting

2019-02-08 Thread Mark Rotteveel
On 8-2-2019 11:24, Jiří Činčura wrote: Hi, is there a way to change the intial value of generator/sequence *without* restarting it? Based on its name, I would guess this is the task for 'START WITH' clause in: CREATE OR ALTER SEQUENCE START WITH Unfortunately it behaves as ALTER

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Dimitry Sibiryakov
08.02.2019 14:01, Jiří Činčura wrote: ALTER SEQUENCE? But please explain what do you mean under 'restart'. Without changing the current value. Try CREATE OR ALTER SEQUENCE. I cannot remember if I ported this improvement from Avalerion to main tree. -- WBR, SD. Firebird-Devel mailing

Re: [Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
> ALTER SEQUENCE? > But please explain what do you mean under 'restart'. Without changing the current value. -- 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] Changing generator's initial value without restarting

2019-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/19 1:24 PM, Jiří Činčura wrote: Hi, is there a way to change the intial value of generator/sequence *without* restarting it? ALTER SEQUENCE? But please explain what do you mean under 'restart'. Firebird-Devel mailing list, web interface at

[Firebird-devel] Changing generator's initial value without restarting

2019-02-08 Thread Jiří Činčura
Hi, is there a way to change the intial value of generator/sequence *without* restarting it? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel