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 SEQUENCE  RESTART WITH 

So it doesn't seem that there is any option.

Mark
--
Mark Rotteveel


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 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 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 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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel