By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Unit testing plpgsql code

P: n/a
Anyone know of a unit testing framework for plpgsql stored procedures?
We are about to convert a bunch of stored procedures from Oracle over
to Postgresql. We currently use the utPLSQL package to unit test
those, so something comparable to it would be optimal.

We'll probably roll our own if nothing currently exists, but I figured
it was worth it to ask first before reinventing the wheel.

TIA,

-Casey

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ben
I made something for one of my projects. I'm really not happy with it
(it borders on unmaintainable) but it does work and if you're desperate
I could share. But I wouldn't be unhappy if you rolled your own, so I
could use that. :)

On Nov 20, 2004, at 7:33 PM, Casey Duncan wrote:
Anyone know of a unit testing framework for plpgsql stored procedures?
We are about to convert a bunch of stored procedures from Oracle over
to Postgresql. We currently use the utPLSQL package to unit test
those, so something comparable to it would be optimal.

We'll probably roll our own if nothing currently exists, but I figured
it was worth it to ask first before reinventing the wheel.

TIA,

-Casey

---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.