#13563: PostgreSQL - batch import on cidr, macaddress column gives error

tariqrahiman reported 2015-07-22T20:51:36Z · last modified 2015-07-24T00:04:06Z

PostgreSQL - batch import on cidr, macaddress column gives error

Dev	JennyNishimura
QA	tariqrahiman

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 cidd, macaddress using batch mode. File is attached

Import started ...

ERROR: column "addr" is of type cidr 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.adns_address (

id int4 NOT NULL,

addr inet NOT NULL,

addr2 macaddr NULL,

cidr1 cidr NULL

)

1 attachment

%2213558.csv%22 copy

2015-07-22T20:51:36Z

197 B

All Comments (2) Change History

nishtha(*) 2015-07-23T05:49:09Z

Verified in ADS 16.0.5-20.

tariqrahiman 2015-07-24T00:04:06Z

Verified in ADS v16.0.5-21

Search Tips

Aqua Data Studio / nhilam

PostgreSQL - batch import on cidr, macaddress column gives error

1 attachment

Issue #13563

Completion

Search Tips

Aqua Data Studio / nhilam

Title

PostgreSQL - batch import on cidr, macaddress column gives error

1 attachment

Issue #13563

Completion