/ All posts
- M8 Error exporting WKB to Postgres 10
I am running Manifold 8.0.30 and do weekly data exports to a Postgres 10 + PostGIS database. To Export the geometry column my query for the result that get exported uses
CGeomWKB(Geom([ID])) AS [wkb]
This has been working with no issues for over a year and suddenly this week almost as soon as Manifold starts exporting I get the following error:
ERROR: current transaction block is aborted, commands ignored until end of transaction block
I tried running "Normalize topology" before exporting but get the same error. If I exclude the [wkb] column the other data exports with no problem.
It does seem to be specific records that are causing the problem. How would one go about "fixing" them?
The geoms are all areas (land parcel boundaries). The error occurs when Manifold exports and is creating a new table so there are no PostgreSQL triggers in play at this stage. The column type created in PostgreSQL is the very generic public.geometry.
If I export
CStr(CGeomWKB(Geom([ID]))) AS [wkt]
it works. From this I can see none of the values are NULL.
I will only be able to test exporting from Manifold 9 on Monday.