1DBIx::Class::Storage::DUBsIe:r:PCgo(n3t)ributed Perl DocDuBmIexn:t:aCtliaosns::Storage::DBI::Pg(3)
2
3
4
6 DBIx::Class::Storage::DBI::Pg - Automatic primary key class for
7 PostgreSQL
8
10 # In your result (table) classes
11 use base 'DBIx::Class::Core';
12 __PACKAGE__->set_primary_key('id');
13 __PACKAGE__->sequence('mysequence');
14
16 This class implements autoincrements for PostgreSQL.
17
19 This driver supports multiple PostgreSQL schemas, with one caveat: for
20 performance reasons, data about the search path, sequence names, and so
21 forth is queried as needed and CACHED for subsequent uses.
22
23 For this reason, once your schema is instantiated, you should not
24 change the PostgreSQL schema search path for that schema's database
25 connection. If you do, Bad Things may happen.
26
27 You should do any necessary manipulation of the search path BEFORE
28 instantiating your schema object, or as part of the on_connect_do
29 option to connect(), for example:
30
31 my $schema = My::Schema->connect
32 ( $dsn,$user,$pass,
33 { on_connect_do =>
34 [ 'SET search_path TO myschema, foo, public' ],
35 },
36 );
37
39 See "CONTRIBUTORS" in DBIx::Class
40
42 You may distribute this code under the same terms as Perl itself.
43
44
45
46perl v5.12.0 2010-05-12 DBIx::Class::Storage::DBI::Pg(3)