NAME

       DBIx::Class::Storage::DBI::Pg - Automatic primary key class for PostgreSQL

SYNOPSIS

         # In your result (table) classes
         use base 'DBIx::Class::Core';
         __PACKAGE__->set_primary_key('id');

DESCRIPTION

       This class implements autoincrements for PostgreSQL.

POSTGRESQL SCHEMA SUPPORT

       This driver supports multiple PostgreSQL schemas, with one caveat: for performance
       reasons, data about the search path, sequence names, and so forth is queried as needed and
       CACHED for subsequent uses.

       For this reason, once your schema is instantiated, you should not change the PostgreSQL
       schema search path for that schema's database connection. If you do, Bad Things may
       happen.

       You should do any necessary manipulation of the search path BEFORE instantiating your
       schema object, or as part of the on_connect_do option to connect(), for example:

          my $schema = My::Schema->connect
                         ( $dsn,$user,$pass,
                           { on_connect_do =>
                               [ 'SET search_path TO myschema, foo, public' ],
                           },
                         );

FURTHER QUESTIONS?

       Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE

       This module is free software copyright by the DBIx::Class (DBIC) authors. You can
       redistribute it and/or modify it under the same terms as the DBIx::Class library.