Re: bug in 1.6 rc1

[Dave Page <dpage(at)postgresql(dot)org>]

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.