Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | 16.0 |
DB: PostgreSQL 9.4.3
I receive the following error when attempting to use the data import tool to import a column of type inet using batch mode.
Import started ...
ERROR: column "addr" is of type inet but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 62
Import completed.
Table schema:
CREATE TABLE public.dns_address (
id int4 NOT NULL,
addr inet NOT NULL
)
GO
|
67 B
Verified in ADS v16.0.5-19
Customer asks: Did you fix all the other uncommon datatypes (macaddr, cidr, uuid, json, enum, bytea) as well?
Fixed all data types - inet, macaddr, cidr, uuid, json, enum, bytea, and all those mentioned in issue #11727.
Customer asks: Did you fix all the other uncommon datatypes (macaddr, cidr, uuid, json, enum, bytea) as well?
Fixed all data types - inet, macaddr, cidr, uuid, json, enum, bytea, and all those mentioned in issue #11727.
In ADS 16.0.5-20, Batch import works for all data types mentioned in issue #11727
But in issue #11727, oid datatype is not mentioned and for oid data type batch import gives error.
I am verifying this issue for all data types except oid and I have filed a new issue 13564 for oid data type batch import error.
In ADS 16.0.5-20, Batch import works for all data types mentioned in issue #11727
But in issue #11727, oid datatype is not mentioned and for oid data type batch import gives error.
I am verifying this issue for all data types except oid and I have filed a new issue 13564 for oid data type batch import error.
Issue #13558 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 16.0.5-20 |
| No time estimate |
1 issue link |
relates to #11727
Issue #11727Import fail for different datatypes in PostgreSQL Database. |
Verified in ADS v16.0.5-19