Re: How can I include sql file in pgTAP unittest?

On 03/02/2018 06:46 AM, Stéphane Klein wrote: Sorry, it is not kea but db2 in my example. I did a mistake when I replace the db name in my example. You need to read:   CREATE EXTENSION IF NOT EXISTS postgres_fdw;   DROP SERVER IF EXISTS db2 CASCADE;   CREATE SERVER db2 FOREIGN DATA WRAP

Re: How can I include sql file in pgTAP unittest?

2018-03-02 14:52 GMT+01:00 Adrian Klaver : > On 03/02/2018 01:17 AM, Stéphane Klein wrote: > >> Hi, >> >> context: I would like to write UnitTest to test pgSQL triggers which use >> postgres_fdw extension. >> I use pgTAP to write this UnitTest (I use this >> Docker environment

Re: How can I include sql file in pgTAP unittest?

On 03/02/2018 01:17 AM, Stéphane Klein wrote: Hi, context: I would like to write UnitTest to test pgSQL triggers which use postgres_fdw extension. I use pgTAP to write this UnitTest (I use this Docker environment poc-postgresql-pgTAP

How can I include sql file in pgTAP unittest?

Hi, context: I would like to write UnitTest to test pgSQL triggers which use postgres_fdw extension. I use pgTAP to write this UnitTest (I use this Docker environment poc-postgresql-pgTAP ). All works perfectly with this test fi