On 20/06/2021 14:24, Vijaykumar Jain wrote:
This was a wrong suggestion. sorry.
i'll try to reproduce what resulted in functions not getting loaded
in your case.
ok i guess you have a typo there. the function name is *no_plan()*, but
you called *noplan() *
Aaaargh - you're right
>
>
> This was a wrong suggestion. sorry.
> i'll try to reproduce what resulted in functions not getting loaded in
> your case.
>
>
ok i guess you have a typo there. the function name is *no_plan()*, but you
called *noplan() *
tt=# select * from noplan();
ERROR: function noplan() does not exist
ignore,
I was wrong.
the script gets loaded by enabling the extension.
postgres@db:~/postgresql-14beta1/contrib/pgtap$ dropdb test
postgres@db:~/postgresql-14beta1/contrib/pgtap$
postgres@db:~/postgresql-14beta1/contrib/pgtap$ createdb test
postgres@db:~/postgresql-14beta1/contrib/pgtap$ psql test
On Sun, 20 Jun 2021 at 17:18, Ray O'Donnell 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 expli
