pgsql2shp error: Invalid byte sequence/table does not exist

المشرف العام

Administrator
طاقم الإدارة
I am exporting tables from Postgresql 9.2 to shapefiles using postgis 2.0. I have the same system on other machines and it works correctly. I have tried running the command from a prompt and get:

Error querying attribute: ERROR: invalid byte sequence for encoding "UTF8": 0x8f

If I try running the command again I get a statement that the table does not exist and it lists a truncated version of my table name.

The error seems to have something to do with the input data format, but I have looked at the data and can't find any unusual characters. I have also used the same shapefile that the table is based off in other applications with sucess.

UPDATE: I thought this may have been caused during the restore from the other database where I have a working version, but I also tried directly adding the original shapefiles to this non-working version with no luck.



أكثر...
 
أعلى