Re: View's rule on delete problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stanislaw Tristan" <stas7775(at)i(dot)com(dot)ua>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: View's rule on delete problem
Date: 2004-10-31 15:29:15
Message-ID: 27780.1099236555@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Stanislaw Tristan" <stas7775(at)i(dot)com(dot)ua> writes:
> It's 2 commands, but executing only first. Why?

You didn't show us the view, but I suppose it's an inner join of the two
tables? As soon as you delete the row from the first table, there's no
longer any matching row in the view, so the second command finds no OLD
row to join against.

Consider making the view a LEFT JOIN and being sure to delete from the
righthand table first.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-31 15:31:06 Re: Interpolation of environment variables in SQL at runtime?
Previous Message Tom Lane 2004-10-31 15:25:36 Re: Replicating sequences