PostgreSQL requires all non-aggregated fields to be present in the GROUP BY clause

The error which is seen so often:
for PostgreSQL (and the SQL92 standard AFAIK), all non-aggregated fields must be present in the GROUP BY clause.
In the case of the query below, this is the case for the vid & name fields, and also for the 'weight' field which is in the 'ORDER BY'.

This is a very standard bugreport/patch and should have zero effect on MySQL.