Re: pgTAP installation

2021-06-20 Thread Ray O'Donnell
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

Re: pgTAP installation

2021-06-20 Thread Vijaykumar Jain
> > > 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

Re: pgTAP installation

2021-06-20 Thread Vijaykumar Jain
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

Re: pgTAP installation

2021-06-20 Thread Vijaykumar Jain
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

pgTAP installation

2021-06-20 Thread Ray O'Donnell
Hi all, I'm just tipping my toe into the water with pgTAP for the first time, and must be doing something wrong - I can't seem to get it working. I'm on Kubuntu Hirsute, and I've installed both PostgreSQL 13 and pgTAP from apt.postgresql.org: sudo apt install postgresql-13 sudo apt in