Menu

#24 SQL completely broke on PostgreSQL.

open
nobody
None
5
2006-05-08
2006-05-08
Mike Benoit
No

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

Discussion


Log in to post a comment.