I am in the process of migrating a server between machines. The old
machine was running PostGreSQL 7.1.3 (compiled from source) on a RH 7.0 Linux
system. The new machine is running the debian postgresql-7.2.1-2 on
Debian (Woody).
Initially I tried using pg_dumpall to replicate the datbases, but
psql generated errors after created the users. I then dropped the users
and added the users and databases by hand, using pg_dump <database> > file and
psql <database> < file for each database seperately. This process was
completed without errors.
Many queries seem to work and most of my dynamic sites are operational,
however, several queries generate an error message.
Sample query causing the problem:
SELECT distinct title, collections.collectionid FROM collections
LEFT OUTER JOIN team_items ON
(collections.collectionid=team_items.collectionid)
LEFT OUTER JOIN item_status ON
(team_items.statusid=item_status.statusid)
WHERE libraryid=1 AND (item_status IS NULL
OR item_status.name<>'REFERENCE')
ORDER BY title LIMIT 20 OFFSET 0;
Resulting error message:
ERROR: ExecEvalExpr: unknown expression type 704
There are some references to this message in the mailing list archives, from
June of last year referencing a "SELECT foo FROM foo;" however that doesn't
seem to apply in this case.
Thank you.
Eric Nielsen
