If I use ExtractSchema(), it dumps SERIAL columns as
integers, and booleans as type "L" with length 1. Both
of which break when you try to ParseSchema() to get
usable SQL:
Example:
<table name="absence_policy">
<field name="id" type="I" size="4">
<NOTNULL/>
<DEFAULT
value="nextval('absence_policy_id_seq'::regclass)"/>
</field>
<field name="over_time" type="L" size="1">
<NOTNULL/>
<DEFAULT value="false"/>
</field>
Converts to:
CREATE TABLE absence_policy (
id INTEGER DEFAULT
'nextval(''absence_policy_id_seq''::regclass)' NOT NULL,
over_time BOOLEAN(1) DEFAULT 'false' NOT NULL,
);
Which doesn't parse at all of course with PostgreSQL 8.1