Forum OpenACS Q&A: Re: Postgres
ERROR: variable not found in subplan target lists
but I guess that is fixed on recent pg versions, judging from this changelog entry: http://www.postgresql.com/news/173.html
So if you go to pg 7.4 make sure you install the latest released version.
Also note that when restoring a dump into a 7.4 database it is not necessary anymore to manually run acs-kernel/sql/postgresql/postgresql.sql before the restore, on the contrary the restore will fail if you do this before. At least that was my experience - could anyone confirm this behaviour? If yes then we should get this in the docs.
Thanks very much for taking the time to reply.
I will do exactly as you suggest. The only bit I am unclear on is where you said:
"You might want to run your dump (just scheme, not data) into a virgin PG 7.2 instance to look for such
truncations so you can fix them in your own code as well as "our" code when you restore into 7.3 or 7.4 (only functions, index name truncation and the like are
Do I need to do this with PG 7.2 before I try running a restore into 7.4?