eulerto / pgquarrel

pgquarrel compares PostgreSQL database schemas (DDL)
BSD 3-Clause "New" or "Revised" License
388 stars 42 forks source link

Fixed trigger order in getTriggers #53

Closed rafalcieslak closed 6 years ago

rafalcieslak commented 6 years ago

The getTriggers function does not order results when fetching trigger list from Postgres. This causes pgquarrel to non-deterministically report differences on identical databases, when the returned trigger order did not match.

This branch fixes this by adding an extra ORDER BY clause to getTriggers' query, similar to queries for other entities.