pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Luis Sousa <llsousa@ualg.pt>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql sql Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Problems using a rule with the WHERE clause
Date: Thu, 28 Jun 2001 11:13:41 +0100
Message-ID: <3B3B0355.CC5336C6@ualg.pt> (raw)
References: <3B3753FB.2E1BA9B0@ualg.pt>
	<16743.993492071@sss.pgh.pa.us>
	<3B385B5E.A8A31C59@ualg.pt>
	<3075.993566480@sss.pgh.pa.us>

> 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

Attachments:

  example_that_works.tar.gz (application/x-gzip, 678B) download

  script_def.tar.gz (application/x-gzip, 1.6K) download

view thread (6+ messages)  latest in thread

Message-ID: <3B3B0355.CC5336C6@ualg.pt>
Permalink:  ../3B3B0355.CC5336C6@ualg.pt/
Also on:    postgresql.org/message-id/3B3B0355.CC5336C6@ualg.pt

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: llsousa@ualg.pt, tgl@sss.pgh.pa.us
  Subject: Re: Problems using a rule with the WHERE clause
  In-Reply-To: <3B3B0355.CC5336C6@ualg.pt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox