SEO

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><s bcs><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_helpe
r_req>No</ip_helper_req><network_sec_int>FALSE</network_sec_int><default_gw_
loc>No</default_gw_loc></options><ipspaces><subnet><circuitid>4444444</circu
itid><ipaddress>10.0.1.1</ipaddress><network>10.0.1.0/24</network><default_r
outer>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</wannetwo
rk></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><h
ost>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:dpage@postgresql.org]
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_re
q>N/A</ip_helper_req><network_sec_int>FALSE</network_sec_int><default_gw_loc
>No</default_gw_loc></options><ipspaces><subnet><circuitid>4444444</circuiti
d><ipaddress>10.0.1.1</ipaddress><network>10.0.1.0/24</network><default_rout
er>10.0.1.1</default_router><primary_dns>10.0.0.5</primary_dns><secondary_dn
s>10.0.0.6</secondary_dns><cpe_primary_dns>111.222.333.2</cpe_primary_dns><c
pe_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.

Belbin, Peter wrote:
> 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;

Thanks. It appears that the error is actually that MakeKey() is failing
to create a proper WHERE clause for the update query in cases where a
table has both OIDs and a primary key. I've fixed that bug in SVN and
your example now works fine.

Thanks for the report.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org