Postgres Pro
Downloads
Home   >   mailing lists

Multiple Rules :: Postgres Is confused !! - Mailing list pgsql-general

From Najib Abi Fadel
Subject Multiple Rules :: Postgres Is confused !!
Date
Msg-id 006d01c4a607$58ed5ff0$f664a8c0@najib
Whole thread Raw
Responses Re: Multiple Rules :: Postgres Is confused !!  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view
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 ...
 
 

pgsql-general by date:

Previous
From:
Date:
Subject: Composite Type Argument Construction to a Function
Next
From:
Date:
Subject: Re: Syntax Issue in Trigger Function??