Re: BUG #8577: pg_dump custom format exported dump can't be imported again - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #8577: pg_dump custom format exported dump can't be imported again
Date
Msg-id 1383688764.54878.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: BUG #8577: pg_dump custom format exported dump can't be imported again  (Dominik Dorn <dominik@dominikdorn.com>)
List pgsql-bugs
Dominik Dorn <dominik@dominikdorn.com> wrote:=0A=0A> How do I delete it fro=
m there there?=0A> lyriks=3D> DELETE FROM lytartist where ctid =3D (284,60)=
;=0A> ERROR:=A0 operator does not exist: tid =3D record=0A> LINE 1: DELETE =
FROM lytartist where ctid =3D (284,60);=0A>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 ^=0A> HINT:=A0 No operator matches the given name and argum=
ent type(s).=0A> You might need to add explicit type casts.=0A=0ADELETE FRO=
M lytartist where ctid =3D '(284,60)';=0A=0A> And how can I prevent inserts=
 like these in the future?=0A=0AI would start by applying any updates avail=
able for the firmware,=0AOS, storage drivers, and PostgreSQL.=A0 And I woul=
d probably schedule=0Aa hardware check for the next suitable maintenance wi=
ndow.=0A=0A--=0AKevin Grittner=0AEDB: http://www.enterprisedb.com=0AThe Ent=
erprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #8577: pg_dump custom format exported dump can't be imported again
Next
From: Tom Lane
Date:
Subject: Re: Bad pg_stats.correlation with repeated keys.