dbix::class::storage::dbi::pg(3pm) [debian man page]

DBIx::Class::Storage::DBI::Pg(3pm)			User Contributed Perl Documentation			DBIx::Class::Storage::DBI::Pg(3pm)

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' ],
			   },
			 );

AUTHORS

       See "CONTRIBUTORS" in DBIx::Class

LICENSE

       You may distribute this code under the same terms as Perl itself.

perl v5.14.2							    2011-11-29					DBIx::Class::Storage::DBI::Pg(3pm)