Re: bug in 1.6 rc1 - Mailing list pgadmin-support

<p><font size="2">Seems that the closing quote is missing, along with a bunch of the previously existing column
data.</font><p><fontsize="2">This appears to be the relevant portion:</font><p><font size="2">2006-11-06 09:25:46
QUERY : Scalar query (byoslab2:5432): SELECT version();</font><br /><font size="2">2006-11-06 09:25:46 QUERY  : Query
result:PostgreSQL 8.1.4 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.3.2</font><br /><font size="2">2006-11-06
09:25:46QUERY  : Void query (byoslab2:5432): UPDATE st_txn SET payload='<vsr><result><sbcs><sbc
id="1"><sbcElement/><sbcName /><sbcName /><ip /></sbc><sbc id="2"><sbcElement
/><sbcName/><sbcName /><ip /></sbc><sbcMarket
/></sbcs><options><vpn_id>22222</vpn_id><dhcp_by>zzzz</dhcp_by><ip_helper_req>N/A</ip_helper_req><network_sec_int>FALSE</network_sec_int><default_gw_loc>No</default_gw_loc></options><ipspaces><subnet><circuitid>4444444</circuitid><ipaddress>10.0.1.1</ipaddress><network>10.0.1.0/24</network><default_router>10.0.1.1</default_router><primary_dns>10.0.0.5</primary_dns><secondary_dns>10.0.0.6</secondary_dns><cpe_primary_dns>111.222.333.2</cpe_primary_dns><cpe_secondary_dns>333.333.333.33</cpe_secondary_dns><domain_name
/><ip_helper_primary/><ip_helper_secondary /><ip_route /><vpn_sbc_static_route_1
/><vpn_sbc_static_route_2/><wancpeip>88.888.888.88</wancpeip><LanStaticPool start="10.0.1.2"
stop="10.0.1.100"/><LanDhcpPool start="10.0.1.101" stop="10.0.1.254"
/><wanaggip>63.252.159.97</wanaggip><wannetwork>63.2</font><p><fontsize="2">2006-11-06 09:25:46
ERROR : ERROR:  syntax error at end of input at character 2130</font><br /><br /><br /><br /><br /><br /><br /><br
/><p><fontsize="2">-----Original Message-----</font><br /><font size="2">From: Dave Page [<a
href="mailto:dpage@postgresql.org">mailto:dpage@postgresql.org</a>]</font><br /><font size="2">Sent: Saturday, November
04,2006 10:45 AM</font><br /><font size="2">To: Belbin, Peter</font><br /><font size="2">Cc:
'pgadmin-support@postgresql.org'</font><br/><font size="2">Subject: Re: [pgadmin-support] bug in 1.6 rc1</font><p><font
size="2">Belbin,Peter wrote:</font><br /><font size="2">> a)</font><br /><font size="2">> </font><br /><font
size="2">> </font><br /><font size="2">> </font><br /><font size="2">> I'm using the windows version of the
latest1.6rc1 release of </font><br /><font size="2">> pgAdmin-III, and have a consistently reproducible
error.</font><br/><font size="2">> </font><br /><font size="2">>  </font><br /><font size="2">> </font><br
/><fontsize="2">> Here are the steps to reproduce it:</font><br /><font size="2">> </font><br /><font
size="2">> </font><br /><font size="2">> </font><br /><font size="2">> After selecting a table, and using the
context(right-click-popup) menu </font><br /><font size="2">> and choosing 'View Data->View All Rows' to get the
EditData window, </font><br /><font size="2">> then selecting row and column defined as 'character varying(65000)',
and</font><br /><font size="2">> editing the contained xml, moving away (clicking on another row) </font><br /><font
size="2">>produces the following error message:</font><br /><font size="2">> </font><p><font size="2">Can you
enablequery logging on your server and see what is actually </font><br /><font size="2">being sent to the server
please?</font><p><fontsize="2">> </font><br /><font size="2">> Subsequent attempts to move to another row
producesa dialog box </font><br /><font size="2">> querying whether I want to save changes, which leads to another
ofthe </font><br /><font size="2">> above messages appearing.</font><br /><font size="2">> </font><br /><font
size="2">></font><br /><font size="2">> Ie: it enters some sort of loop where it knows data has not been saved,
</font><br/><font size="2">> but errors out when trying to save it, which sets it up for another </font><br /><font
size="2">>iteration of the error cycle.</font><br /><font size="2">> </font><p><font size="2">That's intended -
it'sso you don't lose the text you might have just </font><br /><font size="2">spend five minutes typing in (which can
beannoying if the error was </font><br /><font size="2">caused by a simple constraint error for example. To get out of
theloop, </font><br /><font size="2">after you see the error either fix it, or hit the undo button to revert </font><br
/><fontsize="2">the changes you've made.</font><p><font size="2">>  </font><br /><font size="2">> </font><br
/><fontsize="2">> I rather like the ability to just bring up the entire table with a </font><br /><font
size="2">>single click rather than continually having to navigate into the </font><br /><font size="2">> sub-menu
ofthe context menu that appears when you're on a table / view </font><br /><font size="2">> type object in the
hierarchyon the left.</font><br /><font size="2">> </font><br /><font size="2">>  </font><br /><font
size="2">></font><br /><font size="2">> Is there a way to customize the context menu so that the 'favourite'
</font><br/><font size="2">> edit window option can be moved to the top layer of the context menu to </font><br
/><fontsize="2">> save having to continually navigate into the sub-menu?</font><br /><font size="2">> </font><br
/><fontsize="2">>  </font><br /><font size="2">> </font><br /><font size="2">> This would be a nice
customizationcapability if it's not already </font><br /><font size="2">> there.....  if it is already there, do
tell.</font><p><fontsize="2">No, this is not currently possible on the context menu, but you can just </font><br
/><fontsize="2">hit the button on the toolbar.</font><p><font size="2">Regards, Dave</font><br /><br /><p><b><font
size="2">NOTICE:This electronic mail transmission may contain confidential information and is intended only for the
person(s)named.  Any use, copying or disclosure by any other person is strictly prohibited. If you have received this
transmissionin error, please notify the sender via e-mail.</font></b><br /><br />