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??
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.
