Neil Dugan <postgres@butterflystitches.com.au> writes:
> I have been having some trouble with a particular table view. An UPDATE
> command is not only changing the applicable record it is also creating a
> new record as well.
I think it's because your UPDATE is updating supplier.account_type which
is part of the join key for the view's underlying join. Somehow that
results in the update applying to all supplier rows that join to the
same account_type row. Don't have time now to work out exactly why ...
but the easiest solution is probably to not use a join in the view.
Instead fetch the account_type.name via a subselect in the view's
output list.
regards, tom lane