On Sun, 20 Jun 2021 at 17:18, Ray O'Donnell <ray@xxxxxxxxxxxx> 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
ray@xxxxxxxxxxxx
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.
where it says-- Load the TAP functions.
Thanks,
Vijay
Mumbai, India
