pgtap

pgtap copied to clipboard

Travis broken for < 9.4

8

Travis no longer passes for master. https://travis-ci.org/theory/pgtap/builds/496774630 shows as clean, but that’s from 7 months ago. https://travis-ci.org/nasbyj/pgtap/builds/591752270 is a straight branch right off of master and it’s broken. The bottom...

nasbyj

Currently the `coltap` and `hastap` tests can't run in parallel, presumably due to a name conflict. It'd be nice to allow them to run in parallel.

decibel

Remove support for pre-9.3

6

I'd like to officially remove support for pre-9.3 versions of Postgres, due to issues in #128. 9.2 went [EOL 6 months ago](https://www.postgresql.org/support/versioning/). https://travis-ci.org/decibel/pgtap/builds/358206497 shows the failures that #128 is getting...

decibel

Any way to check VIEW privileges similar to table_privs_are?

2

I am trying to test what privileges a user has on a view in the same way as `has_table_privs`, although from the docs I could not find a function that...

jamesmbourne

col_is_pk variants

2

There should also be `(name, name, name)` and `(name, name, name[])` versions of `col_is_pk`. Those versions already exist for `col_is_unique()`.

decibel

Split pgtap.sql.in

1

Will you be agree to split the huge pgtap.sql.in in some smaller parts ? It could be done with few impact, * split the files in some parts * add...

rodo

Add is_window() and isnt_window()

2

Add functions to detect if a function is defined as `window function` or not. These functions will work same as `is_definer()` and `is_aggregate()` Ref : https://www.postgresql.org/docs/9.1/static/tutorial-window.html @theory what about the...

rodo

Check if a constraint is validated or not

9

Actually there is no function to check if a constraint is validate or not.

rodo

Allow description to be optional when schema passed to table testing functions

1

Add `schema, table, colname` variations of the table-checking functions (`table_has_column()`, `col_type_is()`, etc.). That is, allow the description to be optional if the schema is included in the function call.

theory

trigger_is(): allow testing function arguments

7

It'd be good if we could verify the arguments (or at least number of arguments) being passed to a trigger function by a specific trigger. According to [1], The arguments...

decibel