[gdal-dev] GeoRaster: problem updating on predefined existing table

[Pasta Bolognese]

> >
> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
> >  georaster:geoserver/geoserver,MFDEVDB
> >
> >  and it works well. Then I've imported another immage using the same
> >  command and it worked well too !
>
> Note that you didn't specify table & column so a table named "GDAL_IMPORT", column "RASTER" was created for you as default.

exactly

>
> >
> >  Then I have decided to use a predefined table.... and here the problems:
> >
> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
> >  georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta
>
> This command is missing the column name after "schema.table" so it is assuming column name "RASTER" as default. Does the table "pasta" existed before that command?

exactly. The table PASTA is created automatically by the command itself.

>
> >  Input file size is 1014, 863
> >  0...10...20...30...40...50...60...70...80...90...100 - done.
> >  Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_33$,33) on
> >  PASTA,RASTER
> >

at this point the table is created by GDAL

> >  C:\>gdal_translate -of georaster  c:\tmp\map.png
> >  georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta
> >  Input file size is 1014, 863
> >  ERROR 1: ORA-00955: name is already used by an existing object
> >  ORA-06512: at line 10
> >
> >  ERROR 1: Create Table Error!
> >
>
> Again, this command is missing the column name too, so I believe it is trying to re-create the table "Pasta" with column "RASTER". Whatever is happening is caused by the error on the command.
>

At this point GDAL should add a new line to the same table....

infact even giving the table name and the column name: (again, the
table is created automatically by GDAL)


C:\>gdal_translate -of georaster  c:\tmp\map.png
georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster
Input file size is 1014, 863
0...10...20...30...40...50...60...70...80...90...100 - done.
Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_42$,42) on
PASTA,RASTER

C:\>gdal_translate -of georaster  c:\tmp\map.png
georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster
Input file size is 1014, 863
ERROR 1: ORA-00955: name is already used by an existing object
ORA-06512: at line 10

ERROR 1: Create Table Error!