On Monday 01 September 2008 06:52:35 pm Ed Leafe wrote: > > I tried to apply the step-by-step-guide to tables in a postgresql > > database, version 7.4. > > When creating the user interface using ClassDesigner.py (chapter 3) > > error messages > > appeared as listed below. Dabo version is 0.8.4, Python version 2.5.1. > > > > It might be that the error was caused by using the postgres function > > "generate_series" > > in the sql string starting at line 110 of dbPostgreSQL.py. This > > function > > is not available > > in version 7.4 of postgresql. > > > > Is this a known problem? Is the only way to avoid it to upgrade to a > > newer version of > > postgresql? Is the information from generate_series essential? > > According to the comment in the code, it says that 7.4 should be > supported. John Fabiani wrote that code; John, can you address this?
When I changed the code to support 8.x I lost the ability to test against 7.4. However, I had two others comfirm all was still working with 7.4 and was informed all worked. In researching the issue (used google) I discovered several pages that suggested "generate_series" was supported at the 7.4 level but I also found one that suggested it was not. So I don't know what to say. It may be that some version 7.4.x had support. However, I did discover at least two pages that provided replacement functions for the 7.3 guys. See below. http://www.nabble.com/Generating-dates-prior-to-generate_series-td9835752.html CREATE OR REPLACE FUNCTION generate_series(int, int) RETURNS setof int AS ' BEGIN FOR i IN $1..$2 LOOP RETURN NEXT i; END LOOP; RETURN; END; ' LANGUAGE plpgsql; That said, I belive the poster can revert to a much earlier version of dbPostgres.py that I know worked with 7.4. I would start with 2740 and work forward to insure that all still worked with Dabo. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
