GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::CLASS::STORAGE::DBI::PG (3)

.ds Aq ’

NAME

DBIx::Class::Storage::DBI::Pg - Automatic primary key class for PostgreSQL

CONTENTS

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.
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::CLASS::STORAGE::DBI::PG (3) 2016-02-11

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.