View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004191 | SymmetricDS | Bug | public | 2019-12-10 19:49 | 2024-01-25 19:11 |
| Reporter | smotycka | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.1 | ||||
| Target Version | 3.14.1 | Fixed in Version | 3.14.1 | ||
| Summary | 0004191: dbexport: MSSQL geometry -> PGSQL varchar(2147483647); better would be TEXT | ||||
| Description | By 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") ); | ||||
| Tags | dbimport/dbexport, ddl/schema | ||||
|
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 | ||
| 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 |