Re: Problems using a rule with the WHERE clause

Поиск
Список
Период
Сортировка
От Luis Sousa
Тема Re: Problems using a rule with the WHERE clause
Дата
Msg-id 3B3B0355.CC5336C6@ualg.pt
обсуждение исходный текст
Ответ на Problems using a rule with the WHERE clause  (Luis Sousa <llsousa@ualg.pt>)
Ответы Re: Problems using a rule with the WHERE clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> 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

Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Kristis Makris
Дата:
Сообщение: Re: Using the extract() function in plpgsql
Следующее
От: "kakerjak"
Дата:
Сообщение: Subquery error. Help please!!