Re: BUG #8577: pg_dump custom format exported dump can't be imported again

Dominik Dorn <dominik(at)dominikdorn(dot)com> wrote:

> How do I delete it from there there?
> lyriks=> DELETE FROM lytartist where ctid = (284,60);
> ERROR:  operator does not exist: tid = record
> LINE 1: DELETE FROM lytartist where ctid = (284,60);
>                                         ^
> HINT:  No operator matches the given name and argument type(s).
> You might need to add explicit type casts.

DELETE FROM lytartist where ctid = '(284,60)';

> And how can I prevent inserts like these in the future?

I would start by applying any updates available for the firmware,
OS, storage drivers, and PostgreSQL.  And I would probably schedule
a hardware check for the next suitable maintenance window.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company