-my $db = DBI->connect($dsn,$dbuser,$dbpass);
+my $db = DBI->connect($dsn,$dbuser,$dbpass,{pg_expand_array => 0});
# there is possibly some redundancy in this query, but it makes
# a lot of the processing simpler.
# there is possibly some redundancy in this query, but it makes
# a lot of the processing simpler.
my $statement = q{
select name, operating_system, os_version, compiler, compiler_version, owner_email,
my $statement = q{
select name, operating_system, os_version, compiler, compiler_version, owner_email,
$row->{branches} =~ s/^\{(.*)\}$/$1/;
my $personalities = $row->{personalities};
$personalities =~ s/^\{(.*)\}$/$1/;
$row->{branches} =~ s/^\{(.*)\}$/$1/;
my $personalities = $row->{personalities};
$personalities =~ s/^\{(.*)\}$/$1/;
$row->{personalities} = [];
foreach my $personality (@personalities)
{
$personality =~ s/^"(.*)"$/$1/;
$personality =~ s/\\(.)/$1/g;
$row->{personalities} = [];
foreach my $personality (@personalities)
{
$personality =~ s/^"(.*)"$/$1/;
$personality =~ s/\\(.)/$1/g;
my ($compiler_version, $os_version, $effective_date) = split(/\t/,$personality);
my ($compiler_version, $os_version, $effective_date) = split(/\t/,$personality);
push(@{$row->{personalities}}, {compiler_version => $compiler_version,
os_version => $os_version,
effective_date => $effective_date });
push(@{$row->{personalities}}, {compiler_version => $compiler_version,
os_version => $os_version,
effective_date => $effective_date });