search

theory / pgtap

PostgreSQL Unit Testing Suite
https://pgtap.org
984 stars 92 forks source link

Question: pgTap on Greenplum? #304

Closed fomcl closed 1 year ago

fomcl commented 1 year ago

Hi,

I was wondering if you know whether pgtap can also be used on Greenplum (database cluster based on postgresql). We're running PostgreSQL 9.4 + Centos 7, if that matters.

Thanks!

Albert-Jan

theory commented 1 year ago

9.4, wow! Honestly I don't know. Probably? Try it and see!

fomcl commented 1 year ago

Hi, it appears to work! :-) We had to install it on all database segments, which makes sensr. I only checked is(). I did get warnings about missing extensions isn and ltree.

Do I need to install pg_trove separately?

theory commented 1 year ago

The isn and ltree warnings are not from pgTAP, which does not require them. Do you mean pg_prove? Yes, that's a Perl app. There is also a pg_prove docker image.