Update to 1.5.6 fails in last step on pgsql backed system ..

scrappy · Post by **scrappy** » Mon Feb 06, 2006 5:48 am

basically, you can't do a VACUUM ANALYZE with tables seperated by commas:

# vacuum analyze faqadminlog, faqadminsessions;
ERROR: syntax error at or near "," at character 27
LINE 1: vacuum analyze faqadminlog, faqadminsessions;

in my acse, I just removed the tables and let it vacuum analyze the whole thing ...

Post by **Thorsten** » Mon Feb 06, 2006 7:24 am

Hi,

oops... I didn't knew that. How can I do this with all tables?

bye
Thorsten

scrappy · Post by **scrappy** » Mon Feb 06, 2006 7:35 am

personally, just do 'VACUUM ANALYZE;' and it will do all tables within that database ... the other option is a loop that goes through and issues a seperate VACUUM ANALYZE for each table ...

Post by **Thorsten** » Mon Feb 06, 2006 7:39 am

Hi,

okay, I'll do the first one and it's fixed in 1.5.7, 1.6.0-dev and 2.0.0-dev. Thanks a lot!

bye
Thorsten