Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Class::Storage::User:Contributed Perl DoDBIx::Class::Storage::DBI::Pg(3)

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.

perl v5.24.1			  2016-06-20  DBIx::Class::Storage::DBI::Pg(3)

NAME | SYNOPSIS | DESCRIPTION | POSTGRESQL SCHEMA SUPPORT | FURTHER QUESTIONS? | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Class::Storage::DBI::Pg&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help