pgtap
pgtap copied to clipboard
theory
PostgreSQL Unit Testing Suite
Add function parameter names matching the docs so parameters can be passed by name on 9.0 and higher.
Do you have access to the DETAIL: portion of the error message? F'rinstance, I'm porting over contrib/cube's tests to pgtap, and I'd like to check for "Different point dimensions in...
This is probably incredibly low on the priority list, but it just occurred to me that there is no has_comment() function. I don't think we need hasnt_comment(), but it could...
Hello guys, I have to update many tests of SQL functions, and it's a tough work because, when we add/update/delete new columns, we have to update all the previous assertions,...
From [the discussion](https://groups.google.com/g/pgtap-users/c/splTpdlP8dk/m/rWghzV3XAwAJ), perhaps we also want to add functions to test whether a column is STORED or GENERATED, as well. See especially [this followup](https://groups.google.com/d/msgid/pgtap-users/e10e9e2d-583b-2f96-98ea-76429d84de98%40pwhome.com) with some useful catalog querying...
hello! We've added a few checks at Beacon: - whether RLS is enabled for a table - array-to-array `set_eq` - whether a column array has an exclusion constraint set -...
It would be useful to be able see if an index is partial and what the clause is. For `index_is_partial`, we can get that with: ```sql SELECT x.indpred IS NOT...
I'm pretty new to pgTAP but I think there is no easy way to check if a trigger event is avaliable at a given table. `rules_are` is similar but that's...
