> that shouldn't happen, in any case. If this is the current release
> (7.1.2)
The version that I'm using is 7.1release-3.potato.1
> then I'd like to see a complete script to reproduce the problem.
> (I don't have time to guess at your table declarations...)
I try a simple example that works fine. (see attached)
Then I create a script from the database only with the main tables that are
involved (see attached - script_def.tar.gz).
When I execute the file run_update, that only updates three fields on the
records with turno=15, I'm getting some errors (sometimes I got the 1st error
and other times I got de 2nd error):
- ERROR: JOIN qualification may not refer to other relations
- ERROR: ExecEvalExpr: unknown expression type 501
The script contains two tables, evento and pessoalEvento, and the view
docentesturno that JOIN's both tables.
The update is done over docentesturno using run_update.
Thank you for your help. Best Regards
Luis Sousa