if firebird supported namespaces/schema AND longer identifiers, this would
be alot simpler.......
On 27 August 2013 14:11, Leyne, Sean <s...@broadviewsoftware.com> wrote:
>
>
> > On 27/08/2013 14:11, Dmitry Yemanov wrote:
> > > 27.08.2013 20: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 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
