Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 76608
Status: resolved
Priority: 0/
Queue: DBD-Pg

People
Owner: greg [...] turnstep.com
Requestors: vol7ron.forum [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: (no value)
Fixed in: 3.0.0



Subject: statistics_info does not return information on functional indices
Postgres allows for something like: CREATE INDEX ON TABLE foo USING (foo_field); CREATE INDEX ON TABLE foo USING (foo_field,bar_field); CREATE INDEX ON TABLE foo USING (lower(foo_field)); But if you call the function, you don't get the returned handles doesn't contain the index that uses a function (last example). $sth = $dbh->statistics_info(undef,'public','foo',undef,undef); print Dumper($sth->fetchall_arrayref);
These are skipped on purpose. I will either figure a way to add them, or update the docs to clarify the omission.
Took some doing, but it should be working now. There is a new field returned named pg_expression, that should contain the correct information for such indexes. git commit 4bc7ac64c1bdee023caf04c71fc4a3626c79e6c2