Re: pgTAP installation

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

In response to

Responses

Browse pgsql-general by date

  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