Multiple Rules :: Postgres Is confused !!

From: "Najib Abi Fadel" <nabifadel(at)usj(dot)edu(dot)lb>
To: "generalpost" <pgsql-general(at)postgresql(dot)org>
Subject: Multiple Rules :: Postgres Is confused !!
Date: 2004-09-29 09:33:10
Message-ID: 006d01c4a607$58ed5ff0$f664a8c0@najib
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all i am running PostgreSQL 7.3.2,

i have a VIEW for which i implemented multiple RULES on UPDATE.

The weird think is that the Update Query corresponding to one of the rules is updating MULTIPLE ROWS even though it should only update one ROW !!

THE WEIRDEST is that when i remove 2 of the update Rules on the VIEW The Update Query Works FINE !!!!

WHY IS THAT HAPPENNING ??

I can provide more details if anyone is ready to help ...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-09-29 09:44:15 Re: sql script confusion
Previous Message Marian POPESCU 2004-09-29 08:59:28 Re: PostgreSQL 8.0.0 Beta 3 Uploaded