From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | "Ray O'Donnell" <ray(at)rodonnell(dot)ie> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pgTAP installation |
Date: | 2021-06-20 13:06:08 |
Message-ID: | CAM+6J94hGe0UK5tut5swtpbvfF-WeEzMUee0ztx6XO+nYfOyDQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, 20 Jun 2021 at 17:18, Ray O'Donnell <ray(at)rodonnell(dot)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
> ray(at)rodonnell(dot)ie
>
>
postgres(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Vijaykumar Jain | 2021-06-20 13:11:57 | Re: pgTAP installation |
Previous Message | Ray O'Donnell | 2021-06-20 11:48:33 | pgTAP installation |