| 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: | 2009-07-11 19:55:16 |
| Message-ID: | 4A58EE24.9050606@kobaz.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
<!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>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Rijkers | 2009-07-11 20:13:31 | whoami server feedback (feature request) |
| Previous Message | Dave Page | 2009-07-11 19:53:01 | Re: Unable to edit views |