Forum OpenACS Development: Would a list of pg7.2 issues be useful?

1: Would a list of pg7.2 issues be useful?

Posted by Marc Spitzer on 07/23/02 08:08 PM

I was thinking something like the oacs 4 porting page for packages,
but for issuses with postgres 7.2+

I would be willing to maintain it.

2: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Don Baccus on 07/23/02 09:25 PM

Sure, go for it! Do you just want to put it in new file storage, or make a wimpy point presentation, or ???

3: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/23/02 09:42 PM

great got any issues other then the doc-api browse pgplsql error?

4: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/23/02 10:02 PM

I was thinking something simple, more likely to get done, like a html table. Something like this: PG 7.2 ISSUES

entered on

entered by

resolved on

resolved by

package effected

problem description

solution with link to page

where solution would be none, patch, workaround, none

I would like to turn it into something cooler, add some stuff to the notes app would probably do it, but right now done is better then cool.

5: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Don Baccus on 07/24/02 01:54 AM

</center>
A table, especially with cool colors like your example, would be great. You can just stuff it into new-file-storage for now. There's active work going on to move our site to 4.x so we don't really want to do any special hacking on the current site.

6: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by David Kuczek on 07/24/02 07:39 AM

Just a sidenote:

I read on the PG hackers list that they are planing a 7.3 beta freeze for September 1st and final release for October/November... (it will provide drop column

7: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Tapiwa Sibanda on 07/24/02 12:35 PM

Just closing a tag

8: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/25/02 01:19 AM

click here to see the very short and incomplete list.(hint hint send me your issues)

9: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Andrei Popov on 07/25/02 03:38 PM

Forgive my ignorance -- but what is the ptoblem with doc-api on 7.2? I am running a (test) OACS site(s) under FreeBSD 4.6 and WNT4 -- I can browse doc-api no probs, see here.

10: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/25/02 05:23 PM

Are you using the 4.5 branch of cvs or the development branch of cvs, I am using the 4.5 branch.

11: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Andrei Popov on 07/29/02 10:06 PM

On my FreeBSD machine CVS/Repository says openacs-4. Last CVS update was about a week back. doc-api works.

My WNT machine runs one of the nightlies -- I think about a month if not more old. doc-api works.

You want to send me an URL that is failing for you?

12: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/30/02 07:13 AM

It could be that I am using an incorrect cvs branch, I am using oacs-4-5 currently. here is one of the things that did not work under 7.2.1 http://netinfo:8000/api-doc/plsql-subprograms-all, the plpgsql browser, it works fine under 7.1.3 though

13: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Andrei Popov on 07/30/02 02:18 PM

Ok, that's one screen before the schreenshot I've posted. We can diff the plsql-subprograms-all*.{adp,tcl,xql} files and see what's different between yours and mine. For starter (that's from WNT machine), some stats:

[ ~/projects/oaks/packages/acs-api-browser/www ]
$ ls -l plsql-sub*-all*
-rw-r--r--    1 a-popov  None          431 Feb 17 23:10 plsql-subprograms-all-oracle.xql
-rw-r--r--    1 a-popov  None          386 Feb 17 23:10 plsql-subprograms-all-postgresql.xql
-rw-r--r--    1 a-popov  None          494 Mar 13  2001 plsql-subprograms-all.adp
-rw-r--r--    1 a-popov  None          772 Feb 17 23:10 plsql-subprograms-all.tcl

and -postgresql.xql file is:

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="all_subprograms">
      <querytext>

        select proname as name, 'FUNCTION' as type
        from pg_proc
        where proowner=(select usesysid from pg_shadow
                        where usename = current_user)
        order by proname

      </querytext>
</fullquery>


</queryset>

14: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Andrei Popov on 07/31/02 06:45 AM

...and on a BSD box all of the above files are exactly the same.

15: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 07/31/02 07:06 AM

I was under the impression that oacs 4.5 was getting the pg72 fixes, from what I have read in the groups I was mistaken. I am ging to try an install from cvs HEAD to see if I have better luck.

16: Response to Would a list of pg7.2 issues be useful? (response to 1)

Posted by Marc Spitzer on 08/09/02 07:39 AM

I found my problem with pg72, user error. I did not create the nsadmin user with all the needed permissions, did not give it the ability to create users so it could not acces pg_shadow.

Thanks for the help.