The user issue is about managing the internal generator. You can do it now, but you need to discover its internal name.
Why complicate things? Identity columns allows the use to put manually generated values. So the ability to manage a sequence is a must-have. And if a object can be managed, it must have a known name. It's exactly like constraints/indexes, so what's wrong? Adriano On 27/08/2013 15:14, Dalton Calford wrote: > if firebird supported namespaces/schema AND longer identifiers, this > would be alot simpler....... > > > > On 27 August 2013 14:11, Leyne, Sean <[email protected] > <mailto:[email protected]>> wrote: > > > > > On 27/08/2013 14:11, Dmitry Yemanov wrote: > > > 27.08.2013 20 <tel:27.08.2013%2020>:03, Adriano dos Santos > Fernandes wrote: > > >> I think an USING clause would be a great addition: > > >> > > >> GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE <name>] > > >> > > >> What do you think? > > > Basically, I don't mind, but the behavior will be different from > > > constraints in regard to the already existing object named <name>. > > > AFAIU, you suggest to reuse the sequence, right? > > > > > No. I do want to name the generated sequence, exactly like > > constraints/indexes. > > But then, isn't the real issue (as reported) about the name which > is used? > > If FB didn't have a 31 character limit for identifiers, the > solution to the issue would to establish a 'standard' for the > sequence names (ie. "{TableName}.{ColumnName}" or > "SEQ.{TableName}.{ColumnName}") just as was done when we changed > the logic which assigned the name for the Primary Key indexes. > > > Sean > > > > ------------------------------------------------------------------------------ > Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! > Discover the easy way to master current and previous Microsoft > technologies > and advance your career. Get an incredible 1,500+ hours of > step-by-step > tutorial videos with LearnDevNow. Subscribe today and save! > > http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk > Firebird-Devel > > <http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk%0AFirebird-Devel> > mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > > > > > ------------------------------------------------------------------------------ > Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! > Discover the easy way to master current and previous Microsoft technologies > and advance your career. Get an incredible 1,500+ hours of step-by-step > tutorial videos with LearnDevNow. Subscribe today and save! > http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
