[CON Devel] drop_table and spatial processing

[Steve Knox]

Mark Janssen wrote:

> I get an error when running "init_project"
>
>     psql: /s1/concept/concept/src/db/spatial.sql:15: ERROR: Function 
> drop_table("unknown") does not exist
>     HINT: No function matches the given name and argument types.....
>
> Jim's internal documentation of the spatial.sql file says the "Note - 
> This Makes use of the drop_table stored procedure (which must be 
> available) to avoid silly error messages when tables do not exist.
>
> So, How to I make sure drop_table is available?
>
> Mark Janssen
> janssen at ladco.org
>
>
> _______________________________________________
> Devel mailing list
> Devel at conceptmodel.org
> http://lists.conceptmodel.org/mailman/listinfo/devel

I assume you did a "create_project" first?
Here's a script I use to create a new project:
"init_project.sh beta4 scenario1 run_control.txt"

#!/bin/sh                                                                               

project=$1
scenario=$2
run_control=$3
if [ "$#" != "3" ]; then
  echo "Usage: init_project.sh project scenario run_control"
  echo "        e.g.: init_project.sh beta4 scenario1 run_control.CO.txt"
  exit
fi
exec > init_project.$project.$scenario.$run_control.log 2>&1
date
echo project is $project
echo scenario is $scenario
echo run_control is $run_control
concept drop_project -n $project
concept create_project -n $project
echo initialize beta project
# initialize beta project
concept init_project -n $project
echo  create stored procedures
concept import_sp -n $project
echo add $scenario
concept add_scenario -n $project -s $scenario
concept init_scenario -n $project -s $scenario
echo globals reference data
concept import_globals -n $project -d 
../concept_projects/$project/globals -t
echo RPO cross-reference data
concept import_rpo -n $project -d ../concept_projects/$project/rpo -t
echo import control file for the scenario
concept import_control -n $project -s $scenario -c 
../concept_projects/$project/$scenario/$run_control
echo import $scenario inventory data
concept import_nei_area -n $project -s $scenario -d 
$CONCEPT_PROJECTS/$project/$scenario/nei
concept import_nei_point -n $project -s $scenario -d 
$CONCEPT_PROJECTS/$project/$scenario/nei
echo run QA routines
concept qa_nei_area -n $project -s $scenario
concept qa_nei_point -n $project -s $scenario
concept import_metdata -n $project -s $scenario -d 
../concept_projects/$project/$scenario/met_data

psql -f ../contrib/lwpostgis.sql
psql -f ../contrib/spatial_ref_sys.sql
#
echo run_grid_definition model
concept run_grid_definition_model -n $project -s $scenario -d 
../concept_projects/$project/$scenario/output
 
date
exit

Steve



-- 
_________________________
Steve Knox
NREL
Room B256
Colorado State University
(970)491-1972