Обсуждение: Updating views does not work
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?
> -----Original Message----- > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > Sent: 06 December 2002 12:54 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Updating views does not work > > > 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? I've just committed changes to fix this to CVS. If you want to try a snapshot build, you can download a tarball from the binaries director on http://cvs.pgadmin.org/. Installation instructions are in the readme. Regards, Dave.
Yes, it looks all OK now! (from my other e-mail address that is registered... will register that one from work too!) Thanks! Michiel Lange At 13:38 6-12-2002 +0000, Dave Page wrote: > > -----Original Message----- > > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > > Sent: 06 December 2002 12:54 > > To: pgadmin-support@postgresql.org > > Subject: [pgadmin-support] Updating views does not work > > > > > > 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? > >I've just committed changes to fix this to CVS. If you want to try a >snapshot build, you can download a tarball from the binaries director on >http://cvs.pgadmin.org/. Installation instructions are in the readme. > >Regards, Dave. > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster