I just did a dump and restore of my database and one of my views did
not recreate.
The error received was :
pg_restore.exe: [archiver (db)] could not execute query: ERROR: column reference "pricinggroupid" is ambiguous
I checked the function in the original database, using PGAdmin, and
the system seemed to have slightly changed my query.
Part of my query was a virtual table (i.e joining on (select *
from ...) as tablename ) and the system changed that to:
(select fielda,fieldb,fieldc from...) the problem is that there were
joined tables in that virtual table with identical fieldnames. As
the optimizer did not qualify the field names with the table names, it
makes ambiguous columns. That being said, the view does work after it
is created.
I assume this is a bug in the view optimization.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
