Re: auto-increment column

Boszormenyi Zoltan <zb@xxxxxxxxxxx> · Tue, 04 Oct 2011 14:24:51 +0200



    Hi,

    
    2011-10-04 14:05 keltezéssel, Robert Buckley írta:
    
      
        Thanks for the replies,
        

        I have one question regarding this
          comment...
        

        "You also need to add a DEFAULT _expression_ and optionally
        make
          the sequence owned by the column:"
        

        What difference does it make if a
              table "owns" a sequence of not?...does this contraint the
              use of the sequence to ONLY that one table?
        

        The sequence will only be used to
              auto-increment the id column in order to have an automatic
              primary key. Could I then somehow use the sequence for all
              tables which need this?
        

        yours,
        

        Rob
      
    
    please, don't use top-posting. It messes up the order of the
    messages.

    
    The sequenced that is OWNED BY a column can of course be used

    by other columns in other tables. You can specify nextval('same
    sequence')

    for any number of columns' default value.

    
    Best regards,

    Zoltán Böszörményi

    
    -- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
     http://www.postgresql.at/