In pgAdminII 1.4.2 I get the following error when I update a view:
An error has occurred in pgAdmin II:frmView.cmdOK_Click:
Number: -2147467259
Description: ERROR: Relation 'contact_klant_view' already exists
(contact_klant_view is a view where I have combined two tables using an
INNER JOIN)
Am I doing something wrong or is pgAdmin doing it? I think pgAdmin tries to
CREATE the view, however it should be ALTER or something like that. Or
can't views be altered?