From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <Michiel_Lange(at)actuera(dot)nl>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Updating views does not work |
Date: | 2002-12-06 13:38:03 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8128D16@mail.vale-housing.co.uk |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Michiel_Lange(at)actuera(dot)nl [mailto:Michiel_Lange(at)actuera(dot)nl]
> Sent: 06 December 2002 12:54
> To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2002-12-06 16:35:11 | modifying existing tables |
Previous Message | Michiel_Lange | 2002-12-06 12:56:41 | Addition to the update view error |