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.