PostgreSQL Adapter and Initial Schema Issue

[crdunwel]

So it's completely painless to use PostgreSQL instead of MySQL aside from one issue with the initial schema. This may not be PostgreSQL specific and may be the version I'm using (9.4.3).

The error

PG::SyntaxError: ERROR:  syntax error at or near "("
LINE 1: SELECT 'boolean(1)'::regtype::oid
               ^
CONTEXT:  invalid type name "boolean(1)"

Caused by See https://github.com/EFForg/phantom-of-the-capitol/blob/master/db/schema.rb#L36 .

If the limit argument is removed then it works fine. This is probably because MySQL stores boolean type as a TINYINT(1) http://stackoverflow.com/questions/11167793/boolean-or-tinyint-confusion . So the limit argument should be unnecessary. Mind if we remove the limit argument to be more cross-database compatible?

[lyndsysimon]

If you wouldn't mind updating the install documentation (or at least making a note), I'd very much appreciate it. PhantomDC is the only service I have that requires MySQL at the moment, and it would be very nice to remove it from my stack.