Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group