Re: Schemas and serials

marcelo <marcelo.nicolet@xxxxxxxxx> · Sun, 30 Jul 2017 14:58:15 -0300



    Addendum:

    
    Some minutes ago, using EMS SQL Manager Lite, I tried what I was
    asking.

    First, I created a new schema. Then, I duplicated some of the
    transactional tables from the public schema, which is acting as a
    definition repository for those tables, to the new "transactional"
    schema. After that, the serial sequence was created in the test
    schema.

    The only caution is to inspect the sql to be executed, checking to
    which schema points every foreign key; the default, obviously, is
    public. That is OK when the FK goes to one of the reference tables;
    but must be changed when it must go to another transactional one.
    The example would be "order" and "order_detail": customer, product,
    etc must be referenced from public, but the FK from order_detail
    must point to season.order.

    
    So, the question is solved, at least using some "postgresql
    complaint" tool.

    
    Marcelo

    
    On 29/07/17 17:17, Melvin Davidson
      wrote:

    
          On Sat, Jul 29, 2017 at 3:38 PM, tel
            medola <tel.medola@xxxxxxxxx>
            wrote:

            
                Depends.
                When you create your tables in new
                  schema, the script was the same from "qa"?
                Sequences, tables, etc.. belong to the
                  schema where was created.
                

                Roberto.
                
                  
                      Em sáb, 29 de jul de 2017 às 16:17, marcelo
                        <marcelo.nicolet@xxxxxxxxx>
                        escreveu:

                      
                      Some days ago
                        I asked regarding tables located in different
                        schemas.

                        Now, my question is

                        Suppose I have two schemas (other than public):
                        "qa" and "production".

                        Initially I create all my tables in "qa". All of
                        them have a primary key

                        of type serial.

                        Later, I will copy the tables definitions to
                        production.

                        It will automatically create the sequences in
                        the new schema, starting

                        at zero?

                        TIA

                        Marcelo

                        
                        --

                        Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)

                        To make changes to your subscription:

                        http://www.postgresql.org/mailpref/pgsql-general

                      
          Marcelo,

            >Initially I create all my tables in "qa". All of them
            have a primary key of type serial.

            >Later, I will copy the tables definitions to production.

            
        A word of caution, creating tables
            in a qa "schema" and then transferring to production is not
            the normal/correct (or safe) way to do development.

          
        The standard procedure is to create
            a seperate "qa" database (and/or server) with the exact same
            schema(s) as production. Then, after testing 

          
        is completed, the schemas/tables are
            copied to production.

          
          -- 

          
            Melvin
                    Davidson

              I reserve the right to
                  fantasize.  Whether or not you 

                wish to share my
                  fantasy is entirely up to you.