× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nishtha(*) reported Jul 23, 2015  · tariqrahiman last modified Jul 24, 2015

PostgreSQL - Batch import on oid datatype column gives error.


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Import Tool
Version 16.0

Product: Aqua Data Studio
Version: 16.0.5-20
Build #: 44849
Build Date: 2015-Jul-22 02:23:11 PM

Operating Environment: Linux (3.13.0-32-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072;  Total=322,961,408;  Free=144,737,424;  CPUs=8

Steps to reproduce the issue :
1) Connect to PostgreSQL server.
2) Create a Table with oid datatype in any schema.

     CREATE TABLE "public"."oid_datatype"  (
          "col_oid"    oid NULL
     )
    GO

3) Insert some data in it.
   
    INSERT INTO "public"."oid_datatype"("col_oid")
           VALUES(1000)
    GO
 

4) Export data of this table into one file (e.g oid.txt).

5) Now try to import data from file into 'oid_datatype' table.

I receive the following error when attempting to use the data import tool to import a column of type oid using batch mode.

Import started ...

Execute batch failed: Batch entry 0 INSERT INTO "public"."oid_datatype"("col_oid")  VALUES('1000.0') was aborted.  Call getNextException to see the cause.

ERROR: column "col_oid" is of type oid but expression is of type double precision
  Hint: You will need to rewrite or cast the expression.
  Position: 56
 

Please refer attached screenshot "Import_oid_datatype.png".

1 attachment
JennyNishimura   Jul 23, 2015
Field Old Value New Value
Dev Assignee SachinPrakash (Sachin Prakash) JennyNishimura (Jenny Nishimura)
JennyNishimura   Jul 23, 2015
Field Old Value New Value
Fixed Build ADS 16.0.5-21
Resolution Fixed
Resolved Date Jul 23, 2015 6:19 PM
Status New Resolved
tariqrahiman   Jul 24, 2015
Field Old Value New Value
Status Resolved Closed

Issue #13564

Closed
Fixed
Resolved Jul 23, 2015
 
 
Completion
No due date
Fixed Build ADS 16.0.5-21
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017