Re: bug in 1.6 rc1 - Mailing list pgadmin-support
From | Belbin, Peter |
---|---|
Subject | Re: bug in 1.6 rc1 |
Date | |
Msg-id | DAC7935736BD9F4AAC601EE021D1B23406133700@txhouexch01.mcld.net Whole thread Raw |
In response to | bug in 1.6 rc1 ("Belbin, Peter" <PBelbin@McLeodUSA.com>) |
Responses |
Re: bug in 1.6 rc1
|
List | pgadmin-support |
<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 />
pgadmin-support by date: