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.