Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Unable to edit views
- From: Mark Murawski <kobaz(at)kobaz(dot)net>
- To: Dave Page <dpage(at)pgadmin(dot)org>
- Cc: pgadmin-support(at)postgresql(dot)org
- Subject: Re: Unable to edit views
- Date: Sat, 11 Jul 2009 15:55:16 -0400
- Message-id: <4A58EE24.9050606@kobaz.net> <text/plain>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#ffffff"> Well, All of my editable views have a unique identifier. Navicat does warn you, that it will use an all old = new type of update when you edit.<br> <br> <br> <br> On 07/11/09 15:53, Dave Page wrote: <blockquote cite="mid:937d27e10907111253s3f16a2f0w381ff56b1b04758f(at)mail(dot)gmail(dot)com" type="cite"> <pre wrap="">On 7/11/09, Mark Murawski <a class="moz-txt-link-rfc2396E" href="mailto:kobaz(at)kobaz(dot)net"><kobaz(at)kobaz(dot)net></a> wrote: </pre> <blockquote type="cite"> <pre wrap="">Feature request: Editing of editable views When you view the data on a view, nothing is editable. Navicat in windows supports editing editable views by using an 'update where all columns = old data, set new data' type of query. </pre> </blockquote> <pre wrap=""><!----> Yikes, thats pretty broken (and one of the reasons pgAdmin doesn't support updateable view editting). </pre> <blockquote type="cite"> <pre wrap="">My projects heavily use editable views, and I'm constantly switching between pgadmin and navicat. </pre> </blockquote> <pre wrap=""><!----> What happens in Navicat if the update rule updates something other than what you thought you were editting? </pre> </blockquote> <br> </body> </html>
- References:
- Unable to edit views
- From: Mark Murawski
- Re: Unable to edit views
- From: Dave Page
- Unable to edit views
- Prev by Date: Re: Unable to edit views
- Next by Date: whoami server feedback (feature request)
- Previous by thread: Re: Unable to edit views
- Next by thread: Feature request: On demand Configuration data save
- Indexes: