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

[Ivan Lucena]

I just noticed from your ticket [http://trac.osgeo.org/gdal/ticket/3681] that you are using GDAL 1.6.3. Right? 

A lot has changed since then. I run the same sequence of options as you and everything works fine in GDAL 1.8dev. 

I believe it should work fine with the current released version too. GDAL 1.7.2.

Please update it and try again.

Regards.

>  -------Original Message-------
>  From: Pasta Bolognese <pasta.bolognese at gmail.com>
>  To: Ivan Lucena <ivan.lucena at pmldnet.com>
>  Cc: gdal-dev at lists.osgeo.org
>  Subject: Re: [gdal-dev] GeoRaster: problem updating on predefined existing table
>  Sent: Jul 12 '10 09:59
>  
>  doing more experiments it results that the error is given ONLY when
>  the schema is given.
>  
>  gdal_translate -of georaster c:\tmp\map.png ^
>                 georaster:geoserver/geoserver,MFDEVDB,GEOSERVER.PASTA
>  _RASTERS,raster ^
>                 -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))"
>  
>  It is using the table GEOSERVER.PASTA _RASTERS. It would work only
>  once. After that it would give the same error ORA-00955)
>  
>  gdal_translate -of georaster c:\tmp\map.png ^
>                 georaster:geoserver/geoserver,MFDEVDB,PASTA _RASTERS,raster ^
>                 -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))"
>  
>  It is using the table PASTA _RASTERSThis would work all the time..
>  
>  Is it working as expected ?
>  
>  On Mon, Jul 12, 2010 at 2:54 PM, Pasta Bolognese
>  <pasta.bolognese at gmail.com> wrote:
>  >> >
>  >> >  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!
>  >
>