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 whole 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 !!!!


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


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-2015 The PostgreSQL Global Development Group