not the MIN cannot be use, is the ctid, how could the ctid in this format?? this ensure cannot be MIN.. please advice, got any unique key?? to do duplicates data??
can you move data to modern database and do deduplication there?
Without MIN on ctid you cannot to do it. You can write a extension in C language, but it is probably out of scope.
if lets say im using v8,3 and i need delete duplicates data without ID column and 8.3 dont have row_number() over function. how do i write the script??
This is not a postgres bug. Please, use correct mailing list.
How about if in version 8.0, how do we use drop table if exists?? If you dont provide this function then provide a script example dude, why pgsql so unfriendly??
This is not a bug.
Please, try to use supported version of PostgreSQL. 8.0 is unsupported maybe ten years.
psql run in fault tolerant mode where errors are ignored. So you can just
drop table sometable;
create table sometable(...);
It should to works. The error messages you can ignore.