DBIx::Class::Storage::User:Contributed Perl DoDBIx::Class::Storage::DBI::Pg(3)NAMEDBIx::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' ],
},
);
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::Storage::DBI::Pg(3)