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.