puppetlabs/puppetdb — pull request #164 by grimradical (2012-05-23 04:37:38+00:00)
Title: (#14659) Compatibility with PG 8.1.x

RHEL5 ships with 8.1.23, and ARRAY declaration syntax was different waaaaaay
back then. Running PuppetDB with that vintage PG results in SQLExceptions
during initial migration.

In particular, while more recent PG versions support data type definitions like
“foo ARRAY NOT NULL”, PG 8.1 requires “foo ARRAY[1] NOT NULL”. The “1” is
ignored by PG (much like how it ignores the size of a VARCHAR column).

Signed-off-by: Deepak Giridharagopal