From: | Michiel Lange <michiel(at)minas(dot)demon(dot)nl> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | <Michiel_Lange(at)actuera(dot)nl>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Updating views does not work |
Date: | 2002-12-06 16:59:53 |
Message-ID: | 5.1.0.14.0.20021206175902.01dc1e70@192.168.1.3 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(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.
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-12-06 17:05:28 | Re: modifying existing tables |
Previous Message | Johnson, Shaunn | 2002-12-06 16:35:11 | modifying existing tables |