View Issue Details

IDProjectCategoryView StatusLast Update
0004191SymmetricDSBugpublic2024-01-25 19:11
Reportersmotycka Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.1 
Target Version3.14.1Fixed in Version3.14.1 
Summary0004191: dbexport: MSSQL geometry -> PGSQL varchar(2147483647); better would be TEXT
DescriptionBy migrating MSSQL geometry data type to PostgreSQL is default coversion-type "VARCHAR(2147483647)"
But PostgreSQL don't accept VARCHAR type with length "2147483647":
psql write error: length for type varchar cannot exceed 10485760

The better solution would be TEXT data type.
Steps To Reproduce
dbexport --engine corp-000 --catalog "SourceMssqlDatabase" --schema "SourceMssqlSchema" --compatible=postgres --no-data --no-foreign-keys --no-indices TableWithGeometry

The output is:
CREATE TABLE "TableWithGeometry"(
    "OBJECTID" INTEGER NOT NULL,
    "Shape" VARCHAR(2147483647),
    PRIMARY KEY ("OBJECTID")
);
Tagsdbimport/dbexport, ddl/schema

Activities

smotycka

2019-12-11 08:54

reporter   ~0001668

corp-000: SQL Server 2012
store-001: PostgreSQL-11.2 & PostGIS-2.5.2

Related Changesets

SymmetricDS: 3.14 39a9d9fb

2022-08-15 19:58:53

evan-miller-jumpmind

Details Diff
0004191: Prevented dbexport from trying to create a Postgres varchar column with a size > 10485760 (used a text column instead) Affected Issues
0004191
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2019-12-10 19:49 smotycka New Issue
2019-12-10 19:49 smotycka Tag Attached: data type
2019-12-10 19:49 smotycka Tag Attached: dbexport
2019-12-11 08:54 smotycka Note Added: 0001668
2022-08-02 15:09 elong Tag Detached: data type
2022-08-02 15:09 elong Tag Attached: ddl/schema
2022-08-15 19:59 emiller Assigned To => emiller
2022-08-15 19:59 emiller Status new => resolved
2022-08-15 19:59 emiller Resolution open => fixed
2022-08-15 19:59 emiller Fixed in Version => 3.14.1
2022-08-15 20:00 Changeset attached => SymmetricDS 3.14 39a9d9fb
2022-08-30 13:04 admin Status resolved => closed
2024-01-25 19:11 elong Tag Attached: dbimport/dbexport
2024-01-25 19:11 elong Tag Detached: dbexport