Heikki Linnakangas a écrit : > Dave Page wrote: >> Guillaume Lelarge wrote: >>> Dave Page a écrit : >>>> Magnus Hagander wrote: >>>>> On Mon, Oct 15, 2007 at 01:55:34PM +0100, Dave Page wrote: >>>>>> Does anyone think we need an RC2 release? The list of changes since RC1 >>>>>> is currently (excluding translations etc): >>>>>> >>>>>> - Icon update >>>>>> - Guard against checking the server version if we're not connected. >>>>>> - Check the PostgreSQL release before adding tablespace query, per >>>>>> reports from Albin Blaschka and Ariel R. Giomi. >>>>>> - Fix the tablespace issue on index and indexconstraint. >>>>>> - Avoid using a correlated subquery that Greenplum doesn't support, per >>>>>> report from Jon Roberts. >>>>>> - Prevent characters being incorrectly stripped from foreign key column >>>>>> names, per Alexander Kirpa >>>>>> - Cleanup some compiler warnings >>>>> The greenplum query shouds like the one that would reallyi need a bit >>>>> larger testing. Meaning it has to run against a bunch of different pg >>>>> versinos. But if you've done that, then I think we're fine. >>>> I've run it against 8.2 and 8.3, but it's not a hugely complex query. >>>> Anyone running SVN-trunk got any older installs running? >>>> >>> I have 7.4-cvs and 8.1-cvs... I'll try on those. >> Thanks. Just tried 7.3 here but it won't build on my Mac :-( > > I can try 7.3, but you'll have to tell me what to test. >
First, you'll need to install some stuff : * create a postgres database ; * change the pgagent.sql file (there's a dollar quote function that disallow it to be used where pre-8.0 release) ; * launch pgagent like this : pgagent hostaddr=IP_ADDR dbname=postgres Then * launch pgAdmin * create a job (http://www.pgadmin.org/docs/dev/pgagent-jobs.html) To be honest, I don't find the pgagent interface when I use my 7.4 and 8.1 cluster. This will take more time than I first thought. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
