Thread: Unit tests

Unit tests

From
"Chris Smith"
Date:
Okay, found the unit test suite.

I'm getting failures from JDBC unit tests in 7.4.1:

    Testcase: testBadStmt(org.postgresql.test.jdbc2.CallableStmtTest): Caused
an ERROR
        ERROR: language "plpgsql" does not exist

and similar errors for 4 other test cases in that file.  Do I need to do
something special to enable plpgsql stored procedures in the backend?

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation


Re: Unit tests

From
Kris Jurka
Date:

On Fri, 13 Feb 2004, Chris Smith wrote:

>     Testcase: testBadStmt(org.postgresql.test.jdbc2.CallableStmtTest): Caused
> an ERROR
>         ERROR: language "plpgsql" does not exist
>
> and similar errors for 4 other test cases in that file.  Do I need to do
> something special to enable plpgsql stored procedures in the backend?
>

Yes run the createlang script.

createlang plpgsql <dbname>

Kris Jurka


Re: Unit tests

From
"Chris Smith"
Date:
Kris Jurka wrote:
> On Fri, 13 Feb 2004, Chris Smith wrote:
>
> >     Testcase:
> > testBadStmt(org.postgresql.test.jdbc2.CallableStmtTest): Caused an
> >         ERROR ERROR: language "plpgsql" does not exist
> >
> > and similar errors for 4 other test cases in that file.  Do I need
> > to do something special to enable plpgsql stored procedures in the
> > backend?
> >
>
> Yes run the createlang script.
>
> createlang plpgsql <dbname>

Thanks!  I've attached a patch to add a note to the README to this effect.

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Attachment

Re: Unit tests

From
Kris Jurka
Date:

On Fri, 13 Feb 2004, Chris Smith wrote:

> > > Do I need to do something special to enable plpgsql stored
> > > procedures in the backend?
> > >
> >
> > Yes run the createlang script.
> > createlang plpgsql <dbname>
>
> Thanks!  I've attached a patch to add a note to the README to this effect.
>

I didn't even know this README file existed.  I doubt many people do.  It
has a number of things that are out of date and needs a more thorough
going over.  I've put dealing with this on my todo list, but it is
perilously close to the bottom.

Kris Jurka