Forum OpenACS Development: Response to Add New Group Type is broken under PG

Collapse
Posted by Steve Woodcock on
Yes, status report is inaccurate. Should say ~50% complete.

There's more to the problem than just a connect by query -- if you follow the code, it executes group_type::new which (amongst other things) causes a new PL/SQL package to be created for the group type. This uses Oracle internal user_arguments and user_objects views which don't have a handy PG equivalent.

I have got group_type::new working in my CVS, but it involves parsing PL/PGSQL source code to extract information provided in the Oracle user_arguments view. I need to look at the rest of the PL/SQL manipulation that's going on with this module and come up with a satisfactory porting solution but I've been too busy lately.

Excepting this package stuff, the outstanding unported queries are all fairly similar/trivial as far as I can remember.

Hope this sheds some light.