On Sun, 20 Jun 2021 at 17:18, Ray O'Donnell <r...@rodonnell.ie> wrote:
>
>
> gfc_booking6_dev=# select * from noplan();
> ERROR: function noplan() does not exist
> LINE 1: select * from noplan();
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
> Am I missing a step somewhere?
>
> Many thanks in advance,
>
> Ray.
>
>
> --
> Raymond O'Donnell // Galway // Ireland
> r...@rodonnell.ie
>
>
postgres@db:~/postgresql-14beta1/contrib/pgtap$ psql test
psql (14beta1)
Type "help" for help.
test=# drop extension pgtap;
DROP EXTENSION
test=#
test=# \df
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)
test=# \i './sql/pgtap.sql' -- Load the TAP functions.
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
test=# \df -- check functions loaded
List of functions
Schema | Name | Result data type |
Argument data types
| Type
--------+-------------------------------+------------------------+----------------------------------------------------------------------
--------------------+------
public | _add | integer | text,
integer
| func
public | _add | integer | text,
integer, text
test=# SELECT * FROM no_plan();
no_plan
---------
(0 rows)
I think you need to load the script to make use of the functions.
pgTAP: Documentation <https://pgtap.org/documentation.html#installation>
where it says
-- Load the TAP functions.
--
Thanks,
Vijay
Mumbai, India
