Thread: ERROR CODE -600

ERROR CODE -600

From
"Mike Sacauskis"
Date:

I’m trying to create a table and an index in postgress using embedded sql in a “C” program.  I’m running on an

 

[11546]: ECPGdebug: set to 1

[11546]: ECPGconnect: opening database mdimg_db on <DEFAULT> port <DEFAULT>

[11546]: ECPGtrans line 82 action = begin transaction connection = mdimg_default_connection

[11546]: ECPGexecute line 128: QUERY: set transaction isolation level read committed  on connection mdimg_default_connection

[11546]: ECPGexecute line 128 Ok: SET

[11546]: ECPGexecute line 114: QUERY: select  DataSetID  , minBaseTime  , maxBaseTime   from MDIMGDatasetDir where DataSetName  = 'p

001000' and TypeID  = 1 and SubTypeID  = 0   on connection mdimg_default_connection

[11546]: raising sqlcode 100 in line 114, 'No data found in line 114.'.

[11546]: ECPGexecute line 106: QUERY: CREATE TABLE p001000 (IMAGEID serial,  FORMATID integer, DATASETID integer, NORTHLAT real, SOU

THLAT real, WESTLON real, EASTLON real, AOINAME varchar(32), IMAGETITLE varchar(97), IMAGEDESCRIP varchar(97), QUALITYINDICATOR smal

lint, DATACATEGORY smallint, CLASSIFICATION varchar(32), RECEIPTMETHOD varchar(32), COMPRESSION varchar(32), ORIGINATINGSITE varchar

(32), BASETIME integer, PROJECTIONID integer, RECEIPTTIME integer, IMAGESIZE integer, IMAGE Oid, PRIMARY KEY (imageid)) on connectio

n mdimg_default_connection

[11546]: ECPGnoticeProcessor: strange warning 'NOTICE:  CREATE TABLE will create implicit sequence 'p001000_imageid_seq' for SERIAL

column 'p001000.imageid'

'

[11546]: raising sqlcode -600

[11546]: ECPGnoticeProcessor: strange warning 'NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'p001000_pkey' for tab

le 'p001000'

'

[11546]: raising sqlcode -600

[11546]: ECPGexecute line 106 Ok: CREATE TABLE

[11546]: ECPGtrans line 238 action = rollback connection = mdimg_default_connection

[11546]: ecpg_finish: finishing mdimg_default_connection.