Here is a table def:
CREATE TABLE st_txn
(
txnid varchar(40),
txnorder varchar(10) NOT NULL,
txnstage varchar(10) NOT NULL,
txnseq varchar(10),
verb varchar(40),
payload varchar(65000),
status varchar(10),
agent varchar(60),
id serial NOT NULL,
CONSTRAINT st_txn_pk PRIMARY KEY (id)
)
WITH OIDS;
Here is some sample data, copied from a problem row:
190450;"";"969729832";"VSR";"";"";"<vsr><result><sbcs><sbc id="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="" /><LanDhcpPool start="" 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"><cmd id="1"><send><![CDATA[set routing-instance 01117 interface lsq-1/3/0.1]]></send></cmd><cmd id="2"><send><![CDATA[set routing-instance 01117 routing-options static route 33.333.333.333/30 preference 150]]></send></cmd><cmd id="3"><send><![CDATA[set routing-instance 01117 routing-options static route 33.333.333.333/30 discard]]></send></cmd><cmd id="4"><send><![CDATA[set class-of-service interfaces lsq-1/3/0 unit 1 scheduler-map VPN-Only]]></send></cmd><cmd id="5"><send><![CDATA[set class-of-service interfaces lsq-1/3/0 unit 1 classifiers dscp VPN-Only]]></send></cmd><cmd id="6"><send><![CDATA[set routing-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"><cmd id="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
-----Original Message-----
From: Dave Page [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2006 10:12 AM
To: Belbin, Peter
Cc: 'pgadmin-support@postgresql.org'
Subject: Re: [pgadmin-support] bug in 1.6 rc1
Belbin, Peter wrote:
> Seems that the closing quote is missing, along with a bunch of the
> previously existing column data.
>
> This appears to be the relevant portion:
>
> 2006-11-06 09:25:46 QUERY : Scalar query (byoslab2:5432): SELECT
> version();
> 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
> 2006-11-06 09:25:46 QUERY : 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
>
> 2006-11-06 09:25:46 ERROR : ERROR: syntax error at end of input at
> character 2130
Hmm - can you supply me with a table definition and some sample data please?
Regards, Dave.
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 transmission in error, please notify the sender via e-mail.
