alzabo::driver::postgresql(3pm) [debian man page]

Alzabo::Driver::PostgreSQL(3pm) 			User Contributed Perl Documentation			   Alzabo::Driver::PostgreSQL(3pm)

NAME

       Alzabo::Driver::PostgreSQL - PostgreSQL specific Alzabo driver subclass

SYNOPSIS

	 use Alzabo::Driver::PostgreSQL;

DESCRIPTION

       This provides some PostgreSQL specific implementations for the virtual methods in Alzabo::Driver.

METHODS

       connect, create_database, drop_database

       Besides the parameters listed in the Alzabo::Driver docs, the following parameters are accepted:

       * options
       * tty

       schemas

       This method accepts the same parameters as the "connect()" method.

       get_last_id

       Returns the last id created for a sequenced column.

       identifier_length

       Returns the maximum identifier length allowed by the database.  This is really a guess based on the server version, since the actual value
       is set when the server is compiled.

BUGS

       In testing, I found that there were some problems using Postgres in a situation where you start the app, connect to the database, get some
       data, fork, reconnect, and and then get more data.  I suspect that this has more to do with the DBD::Pg driver and/or Postgres itself than
       Alzabo.	I don't believe this would be a problem with an app which forks before ever connecting to the database (such as mod_perl).

AUTHOR

       Dave Rolsky, <autarch@urth.org>

perl v5.8.8							    2007-12-23					   Alzabo::Driver::PostgreSQL(3pm)

Alzabo::PostgreSQL(3pm) 				User Contributed Perl Documentation				   Alzabo::PostgreSQL(3pm)

NAME

       Alzabo::PostgreSQL - Alzabo and PostgreSQL

DESCRIPTION

       This documentation is about what special support Alzabo has for PostgreSQL, as well as what is lacking.

       Postgres support is based on the 7.3.x version of Postgres.  Alzabo should work with the 7.1 and 7.2 series, and may even work with the 7.0
       series.

       Mixed-case Table or Column Names

       By default, Postgres treats table and column names case-insensitively.  Because of this, Alzabo always quotes these names when generating
       DDL SQL.  If you are using tables or columns that contain upper-case characters, you should always call "$schema->set_quote_identifiers(1)"
       as soon as you load your schema object.	Otherwise, any method which generates DML SQL will fail.

       Reverse Engineering

       o   Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the
	   sequence was created as a result of making a column's type SERIAL.

	   This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change.

       Transactions

       o   Transactions are fully supported with Postgres.

       Outer joins

       o   Left and right outer joins are supported.

       o   Full outer joins are not supported.

       Constraints

       Column constraints can be specified as column attributes.  Table constraints can be specified as table attributes.

       Foreign key constraints are generated automatically based on the relationships defined by your schema.

perl v5.8.8							    2007-12-23						   Alzabo::PostgreSQL(3pm)