ExecEvalExpr: unknown expression type 704 problems...
От | Eric D Nielsen |
---|---|
Тема | ExecEvalExpr: unknown expression type 704 problems... |
Дата | |
Msg-id | 200207272024.QAA04956@w20-575-86.mit.edu обсуждение исходный текст |
Ответы |
Re: ExecEvalExpr: unknown expression type 704 problems...
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: