bucardo / dbdpg

Perl Postgres driver DBD::Pg aka dbdpg
48 stars 35 forks source link

More statistics_info fixups #70

Closed ilmari closed 4 years ago

ilmari commented 4 years ago

The previous batch of statistics_info fixes was incomplete, and broke things on pre-8.3 servers. As well as fixing that, this fixes the value the ASC_OR_DESC field, and adds a pg_null_ordering field.

A side-effect of the 8.3 fix that the table-level row is now last, instead of first, which might break order-sensitive users. This new behaviour does however match the order implied by the DBI docs, and PostgreSQL's default NULL ordering.