Re: bug in 1.6 rc1

<p><font size="2">Here is a table def:</font><p><font size="2">CREATE TABLE st_txn</font><br /><font
size="2">(</font><br/><font size="2">  txnid varchar(40),</font><br /><font size="2">  txnorder varchar(10) NOT
NULL,</font><br/><font size="2">  txnstage varchar(10) NOT NULL,</font><br /><font size="2">  txnseq
varchar(10),</font><br/><font size="2">  verb varchar(40),</font><br /><font size="2">  payload
varchar(65000),</font><br/><font size="2">  status varchar(10),</font><br /><font size="2">  agent
varchar(60),</font><br/><font size="2">  id serial NOT NULL,</font><br /><font size="2">  CONSTRAINT st_txn_pk PRIMARY
KEY(id)</font><br /><font size="2">) </font><br /><font size="2">WITH OIDS;</font><br /><p><font size="2">Here is some
sampledata, copied from a problem row:</font><p><font
size="2">190450;"";"969729832";"VSR";"";"";"<vsr><result><sbcs><sbcid="1"><sbcElement
/><sbcName/><sbcName /><ip /></sbc><sbc id="2"><sbcElement /><sbcName
/><sbcName/><ip /></sbc><sbcMarket
/></sbcs><options><vpn_id>01117</vpn_id><dhcp_by>Customer</dhcp_by><ip_helper_req>No</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
/><secondary_dns
/><cpe_primary_dns>333.333.333.3</cpe_primary_dns><cpe_secondary_dns>333.333.333.330</cpe_secondary_dns><domain_name
/><ip_helper_primary/><ip_helper_secondary /><ip_route /><vpn_sbc_static_route_1
/><vpn_sbc_static_route_2/><wancpeip>33.333.333.333</wancpeip><LanStaticPool start="" stop=""
/><LanDhcpPoolstart="" stop=""
/><wanaggip>33.333.333.333</wanaggip><wannetwork>33.333.333.333/30</wannetwork></subnet></ipspaces><action><type>vpn</type><hosts><host>aaaaaaaaaaaaa01.bbbbbbbbb.NET</host></hosts><cmds
timeout="20"><cmdid="1"><send><![CDATA[set routing-instance 01117 interface
lsq-1/3/0.1]]></send></cmd><cmdid="2"><send><![CDATA[set routing-instance 01117
routing-optionsstatic route 33.333.333.333/30 preference 150]]></send></cmd><cmd
id="3"><send><![CDATA[setrouting-instance 01117 routing-options static route 33.333.333.333/30
discard]]></send></cmd><cmdid="4"><send><![CDATA[set class-of-service interfaces
lsq-1/3/0unit 1 scheduler-map VPN-Only]]></send></cmd><cmd id="5"><send><![CDATA[set
class-of-serviceinterfaces lsq-1/3/0 unit 1 classifiers dscp VPN-Only]]></send></cmd><cmd
id="6"><send><![CDATA[setrouting-instance 01117 routing-options static route 10.0.1.0/24 next-hop
lsq-1/3/0.1]]></send></cmd></cmds></action><action><type>vpn</type><hosts><host>aaaaaaaaaaaaa02.bbbbbbbbb.NET</host></hosts><cmds
timeout="20"><cmdid="1"><send><![CDATA[set routing-options static route 33.333.333.333/30 next-hop
sp-1/3/0.76]]></send></cmd></cmds></action><code>OK</code></result></vsr>";"";"";4503</font><br
/><br/><p><font size="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: Monday, November
06,2006 10:12 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">> Seems that the closing quote is missing, along with a
bunchof the </font><br /><font size="2">> previously existing column data.</font><br /><font size="2">>
</font><br/><font size="2">> This appears to be the relevant portion:</font><br /><font size="2">> </font><br
/><fontsize="2">> 2006-11-06 09:25:46 QUERY  : Scalar query (byoslab2:5432): SELECT </font><br /><font size="2">>
version();</font><br/><font size="2">> 2006-11-06 09:25:46 QUERY  : Query result: PostgreSQL 8.1.4 on </font><br
/><fontsize="2">> 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 </font><br /><font size="2">> SET
payload='<vsr><result><sbcs><sbcid="1"><sbcElement /><sbcName </font><br /><font
size="2">>/><sbcName /><ip /></sbc><sbc id="2"><sbcElement /><sbcName
/><sbcName</font><br /><font size="2">> /><ip /></sbc><sbcMarket </font><br /><font
size="2">>
/></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
</font><p><fontsize="2">> /><ip_helper_primary /><ip_helper_secondary /><ip_route </font><br
/><fontsize="2">> /><vpn_sbc_static_route_1 /><vpn_sbc_static_route_2 </font><br /><font size="2">>
/><wancpeip>88.888.888.88</wancpeip><LanStaticPoolstart="10.0.1.2" </font><br /><font size="2">>
stop="10.0.1.100"/><LanDhcpPool start="10.0.1.101" stop="10.0.1.254" </font><br /><font size="2">>
/><wanaggip>63.252.159.97</wanaggip><wannetwork>63.2</font><br/><font size="2">> </font><br
/><fontsize="2">> 2006-11-06 09:25:46 ERROR  : ERROR:  syntax error at end of input at </font><br /><font
size="2">>character 2130</font><p><font size="2">Hmm - can you supply me with a table definition and some sample
dataplease?</font><p><font size="2">Regards, Dave.</font><br /><br /><p><b><font size="2">NOTICE: This electronic mail
transmissionmay contain confidential information and is intended only for the person(s) named.  Any use, copying or
disclosureby any other person is strictly prohibited. If you have received this transmission in error, please notify
thesender via e-mail.</font></b><br /><br />