Lets say I am having one database tempdb, in that sequence mysequence exists.
The sequence mysequence's current value is 12.
Now due to some changes that needs to be done in database tempdb, i need to reinstall tempdb database.
Before installing new version tempdb, i need to take the data backup of the current database, so that after installing new version I can put the old data back into the database.
Here is the need of changing the sequence value to 12 without changing its definition, when we put the old data back into the database.
-Ajay
On Fri, 2006-02-24 at 12:29, Karl & Betty Schendel wrote:
At 12:22 PM +0530 2/24/2006, Ajay Dalvi wrote: >... > The after execution of the alter sequence command , if we see the definition of sequence, > by using > > help sequence mysequence \g > > it will show: > > create sequence mysequence as integer > start with 12 > > What I actually want is the behaviour same as if we execute following command 12 times > > select next value for mysequence \g > Hi Ajay, I guess I am stupid tonight. I am not seeing the practical difference between these. You want a sequence to act as if 12 values have been used up, but you don't want the sequence to start at 12? ??? What is the difference between these two, in the real world? Karl _______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
--
This message has been scanned for viruses and
dangerous content by Extenprise mailscanner, and is
believed to be clean.
_______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
