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  -  ALZABO::POSTGRESQL (3)

.ds Aq ’

NAME

Alzabo::PostgreSQL - Alzabo and PostgreSQL

CONTENTS

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.

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 ALZABO::POSTGRESQL (3) 2016-04-03

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