This indicates the PostgreSQL data definition language features supported by each Pyrseas release. Pyrseas supports PostgreSQL versions 8.4, 9.0, 9.1 and 9.2. It is being tested against 9.3beta1. Some of the DDL features are only available in later PostgreSQL versions. Pyrseas can be used with Python 2.6 or 2.7 and starting in version 0.5 with Python 3.2 or 3.3.
| DDL Feature | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 |
|---|---|---|---|---|---|---|
| AGGREGATE | X | X | X | X | ||
| CAST | X | X | X | |||
| COLLATION | X | |||||
| CONSTRAINT TRIGGER | X | X | X | |||
| CONVERSION | X | X | X | |||
| DOMAIN | X | X | X | X | ||
| EXTENSION | X | |||||
| FOREIGN DATA WRAPPER | X | X | ||||
| FOREIGN TABLE | X | X | ||||
| FUNCTION | X | X | X | X | X | |
| INDEX | X | X | X | X | X | X |
| LANGUAGE | X | X | X | X | X | |
| OPERATOR | X | X | X | |||
| OPERATOR CLASS | X | X | X | |||
| OPERATOR FAMILY | X | X | X | |||
| RULE | X | X | X | X | ||
| SCHEMA | X | X | X | X | X | X |
| SEQUENCE | X | X | X | X | X | X |
| SERVER | X | X | ||||
| TABLE | X | X | X | X | X | X |
| – CHECK CONSTRAINT | X | X | X | X | X | X |
| – PRIMARY KEY | X | X | X | X | X | X |
| – FOREIGN KEY | X | X | X | X | X | X |
| – UNIQUE CONSTRAINT | X | X | X | X | X | X |
| – INHERIT | X | X | X | X | X | |
| – UNLOGGED | X | |||||
| TABLESPACE | X | |||||
| TEXT SEARCH CONFIGURATION | X | X | ||||
| TEXT SEARCH DICTIONARY | X | X | ||||
| TEXT SEARCH PARSER | X | X | ||||
| TEXT SEARCH TEMPLATE | X | X | ||||
| TRIGGER | X | X | X | X | ||
| TYPE | X | X | X | X | ||
| – ENUM | X | X | X | X | ||
| – composite | X | X | X | |||
| – base type | X | X | X | |||
| USER MAPPING | X | X | ||||
| VIEW | X | X | X | X | X | |
| COMMENT | X | X | X | X | X | |
| Object OWNER | X | |||||
| Access privileges | X |
PostgreSQL 9.3 features to be added in Pyrseas release 0.7: MATERIALIZED VIEW, EVENT TRIGGER.
