<cnliou(at)eurosport(dot)com> writes:
> When the following rule is created:
> ...
> then postgresql seems to be confused by the following
> SQL such that psql keeps waiting for postgresql's
> result:
Could we see a *complete* example? It's no fun trying to
reverse-engineer your table declarations from just the rule;
let alone any related rules that might be involved, or the
data in the table if the behavior happens to be data-dependent.
regards, tom lane