Re: [WDB-Users] Error while trying to add regular grid

[Michael A. <mic...@me...>]

Hi,

Always good to hear from people working with WDB.

placeregulargrid_skey is a unique index over numberx, numbery, incrementx, incrementy, startx, starty, and originalsrid. Essentially, this means that you are trying to add a place definition to the DB that already exists.

It might be better to take a look at the logs of the loading program for the problem.

Regards,

Michael A.

----- Original Message -----
> Hello
> 
> I'm new to wdb and I have a question: gridload complains that there is
> no place definition point but when I want to add one it complains about
> a foreign key.
> 
> This is the query:
> SELECT wci.begin ( 'wdb', 0, 0, 0 );
> SELECT wci.addplaceregulargrid( 'GribLoad AutoInsert
> 2014-06-22T14:38:40.990488', 400, 241, 0.025, 0.025, 19.5, 43,
> '+proj=longlat +a=6367470.0 +towgs84=0,0,0 +no_defs');
> SELECT wci.end()
> 
> 
> This is the output:
> ERROR:  duplicate key value violates unique constraint
> "placeregulargrid_skey"
> CONTEXT:  SQL statement "INSERT INTO wdb_int.placeregulargrid VALUES (
> $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8  )"
> PL/pgSQL function "addplaceregulargrid" line 34 at SQL statement
> 
> ********** Error **********
> 
> ERROR: duplicate key value violates unique constraint
> "placeregulargrid_skey"
> SQL state: 23505
> Context: SQL statement "INSERT INTO wdb_int.placeregulargrid VALUES (
> $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8  )"
> PL/pgSQL function "addplaceregulargrid" line 34 at SQL statement
> 
> Can you help me please to debug this?
> 
> Thank you!
> 
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
> http://p.sf.net/sfu/hpccsystems
> _______________________________________________
> WDB-Users mailing list
> WDB...@li...
> https://lists.sourceforge.net/lists/listinfo/wdb-users
>