Firebird generators

From: Damir Bijuklic (damirbijukli..ahoo.com)
Date: Wed Mar 23 2005 - 17:15:26 EST

  • Next message: Cris Daniluk: "RE: Firebird generators"

    Hi,

    I have a proposal for addition of sequences for
    Firebird, which i need in a project of mine.

    Firebird has plans for supporting SQL sequences in the
    future (not so near), but for now it has proprietary
    syntax available with
    similar (probably same?) semantics. Firebird calls
    sequences generators and they are accessed in the
    following manner:

            1. creating sequence

    create generator gen_name

            2. fetching next value

    select gen_id(gen_name, 1) from rdb$database

            3. fetching block of next values

    select gen_id(gen_name, 20) from rdb$database

            4. setting value

    set generator gen_name to 200

            5. list generators ?

    select rdb$generator_name from rdb$generators where
    rdb$generator_name not like '%$%'

    Would implementing these be as simple as replacing
    appropriate portions of PostgresPkGenerator and moving
    it into FirebirdPkGenerator ?

    What is the behaviour of cayenne if i already have
    created generators (in the database) from other
    portions of system, how do i supply new initial value
    for non existing generators (ones which cayenne will
    create)?

    Damir Bijuklic

                    
    __________________________________
    Do you Yahoo!?
    Yahoo! Small Business - Try our new resources site!
    http://smallbusiness.yahoo.com/resources/

    This archive was generated by hypermail 2.0.0 : Wed Mar 23 2005 - 17:15:27 EST