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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
