Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx> writes: > Ok, I've found the rows theyh were placed in pg_operator table. After > deletion I get the following error in pg_dump: > pg_dump: Error message from server: ERROR: operator is not unique: smallint > <> integer > LINE 1: ...d = relowner) AS rolname, relchecks, (reltriggers <> 0) AS r... > ^ > HINT: Could not choose a best candidate operator. You may need to add > explicit type casts. Kinda looks like you deleted some rows you shouldn't have ... the above is about what I'd expect to happen if you'd removed the int2 <> int4 operator. Do you know what you removed, exactly? You might try comparing the contents of pg_operator with another, non-broken database, and putting back whatever's missing. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
