[Mapbender-users] Postgresql Errors during installation-trunk version

leonidas leonidas_liakos at yahoo.gr
Wed Apr 17 03:04:12 PDT 2013 

In the log file:
psql:_install.sql:120: NOTICE:  CREATE TABLE will create implicit sequence
"gui_kml_kml_id_seq" for serial column "gui_kml.kml_id"
psql:_install.sql:187: NOTICE:  CREATE TABLE will create implicit sequence
"gui_treegde_id_seq" for serial column "gui_treegde.id"
psql:_install.sql:243: NOTICE:  CREATE TABLE will create implicit sequence
"keyword_keyword_id_seq" for serial column "keyword.keyword_id"
psql:_install.sql:265: NOTICE:  CREATE TABLE will create implicit sequence
"layer_layer_id_seq" for serial column "layer.layer_id"
psql:_install.sql:334: NOTICE:  CREATE TABLE will create implicit sequence
"mb_group_mb_group_id_seq" for serial column "mb_group.mb_group_id"
psql:_install.sql:355: NOTICE:  CREATE TABLE will create implicit sequence
"mb_log_id_seq" for serial column "mb_log.id"
psql:_install.sql:404: NOTICE:  CREATE TABLE will create implicit sequence
"mb_user_mb_user_id_seq" for serial column "mb_user.mb_user_id"
psql:_install.sql:444: NOTICE:  CREATE TABLE will create implicit sequence
"md_topic_category_md_topic_category_id_seq" for serial column
"md_topic_category.md_topic_category_id"
psql:_install.sql:460: NOTICE:  CREATE TABLE will create implicit sequence
"sld_user_layer_sld_user_layer_id_seq" for serial column
"sld_user_layer.sld_user_layer_id"
psql:_install.sql:474: NOTICE:  CREATE TABLE will create implicit sequence
"translations_trs_id_seq" for serial column "translations.trs_id"
psql:_install.sql:512: NOTICE:  CREATE TABLE will create implicit sequence
"wfs_wfs_id_seq" for serial column "wfs.wfs_id"
psql:_install.sql:535: NOTICE:  CREATE TABLE will create implicit sequence
"wfs_conf_wfs_conf_id_seq" for serial column "wfs_conf.wfs_conf_id"
psql:_install.sql:564: NOTICE:  CREATE TABLE will create implicit sequence
"wfs_conf_element_wfs_conf_element_id_seq" for serial column
"wfs_conf_element.wfs_conf_element_id"
psql:_install.sql:578: NOTICE:  CREATE TABLE will create implicit sequence
"wfs_element_element_id_seq" for serial column "wfs_element.element_id"
psql:_install.sql:595: NOTICE:  CREATE TABLE will create implicit sequence
"wfs_featuretype_featuretype_id_seq" for serial column
"wfs_featuretype.featuretype_id"
psql:_install.sql:663: NOTICE:  CREATE TABLE will create implicit sequence
"wms_wms_id_seq" for serial column "wms.wms_id"
psql:_install.sql:710: NOTICE:  ALTER TABLE / ADD UNIQUE will create
implicit index "keyword_keyword_key" for table "keyword"
psql:_install.sql:720: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "mb_gui_kml_pkey" for table "gui_kml"
psql:_install.sql:730: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "md_topic_category_pkey" for table "md_topic_category"
psql:_install.sql:740: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_featuretype_id" for table "wfs_featuretype"
psql:_install.sql:750: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_featuretype_namespace" for table
"wfs_featuretype_namespace"
psql:_install.sql:760: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_gui_id" for table "gui_element"
psql:_install.sql:770: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_gui_id_fkey_e_id_var_name" for table
"gui_element_vars"
psql:_install.sql:780: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_mb_group_id" for table "gui_mb_group"
psql:_install.sql:790: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_mb_user_id" for table "gui_mb_user"
psql:_install.sql:800: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_mb_user_mb_group_id" for table "mb_user_mb_group"
psql:_install.sql:810: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_treegde_id" for table "gui_treegde"
psql:_install.sql:820: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_wfs_conf_id" for table "gui_wfs_conf"
psql:_install.sql:830: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_group_id" for table "mb_group"
psql:_install.sql:840: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_gui_id" for table "gui"
psql:_install.sql:850: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_gui_layer" for table "gui_layer"
psql:_install.sql:860: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_gui_wms" for table "gui_wms"
psql:_install.sql:870: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_keyword_id" for table "keyword"
psql:_install.sql:880: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_layer_id" for table "layer"
psql:_install.sql:890: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_layer_keyword" for table "layer_keyword"
psql:_install.sql:900: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_mb_log" for table "mb_log"
psql:_install.sql:910: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_mb_monitor" for table "mb_monitor"
psql:_install.sql:920: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_mb_user_id" for table "mb_user"
psql:_install.sql:930: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_md_topic_category" for table "wms_md_topic_category"
psql:_install.sql:940: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_sld_user_layer" for table "sld_user_layer"
psql:_install.sql:950: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_user_wmc" for table "mb_user_wmc"
psql:_install.sql:960: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wfs_conf_element_id" for table "wfs_conf_element"
psql:_install.sql:970: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wfs_conf_id" for table "wfs_conf"
psql:_install.sql:980: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wfs_element" for table "wfs_element"
psql:_install.sql:990: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wfs_id" for table "wfs"
psql:_install.sql:1000: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wms_format" for table "wms_format"
psql:_install.sql:1010: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wms_id" for table "wms"
psql:_install.sql:1020: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wms_srs" for table "wms_srs"
psql:_install.sql:1030: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "translations_pkey" for table "translations"
psql:_install.sql:24108: NOTICE:  ALTER TABLE / ADD UNIQUE will create
implicit index "wfs_element_element_id_key" for table "wfs_element"
psql:_install.sql:24408: NOTICE:  CREATE TABLE will create implicit sequence
"gui_category_category_id_seq" for serial column "gui_category.category_id"
psql:_install.sql:24408: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "pk_category_id" for table "gui_category"
psql:_install.sql:25848: NOTICE:  CREATE TABLE will create implicit sequence
"cat_cat_id_seq" for serial column "cat.cat_id"
psql:_install.sql:25852: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "cat_pkey" for table "cat"
psql:_install.sql:25860: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_cat_keyword" for table "cat_keyword"
psql:_install.sql:25891: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "pk_con_cat_op" for table "cat_op_conf"
psql:_install.sql:25941: NOTICE:  table "wmc_keyword" does not exist,
skipping
psql:_install.sql:25942: NOTICE:  table "wmc_md_topic_category" does not
exist, skipping
psql:_install.sql:25947: ERROR:  constraint "mb_user_wmc_pkey" of relation
"mb_user_wmc" does not exist
psql:_install.sql:25960: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_user_wmc" for table "mb_user_wmc"
psql:_install.sql:25968: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_wmc_keyword" for table "wmc_keyword"
psql:_install.sql:26775: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_gui_gui_category" for table "gui_gui_category"
psql:_install.sql:26985: ERROR:  column "featuretype_searchable" of relation
"wfs_featuretype" already exists
psql:_install.sql:27020: NOTICE:  CREATE TABLE will create implicit sequence
"inspire_md_data_data_id_seq" for serial column "inspire_md_data.data_id"
psql:_install.sql:27020: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "data_id_pkey" for table "inspire_md_data"
psql:_install.sql:27042: NOTICE:  CREATE TABLE will create implicit sequence
"conformity_conformity_id_seq" for serial column "conformity.conformity_id"
psql:_install.sql:27042: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "conformity_pkey" for table "conformity"
psql:_install.sql:27065: NOTICE:  CREATE TABLE will create implicit sequence
"spec_classification_spec_class_id_seq" for serial column
"spec_classification.spec_class_id"
psql:_install.sql:27065: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "spec_class_id_pkey" for table "spec_classification"
psql:_install.sql:27065: NOTICE:  CREATE TABLE / UNIQUE will create implicit
index "spec_classification_spec_class_key_key" for table
"spec_classification"
psql:_install.sql:27091: NOTICE:  CREATE TABLE will create implicit sequence
"spec_spec_id_seq" for serial column "spec.spec_id"
psql:_install.sql:27091: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "spec_id_pkey" for table "spec"
psql:_install.sql:27122: NOTICE:  CREATE TABLE will create implicit sequence
"conformity_relation_relation_id_seq" for serial column
"conformity_relation.relation_id"
psql:_install.sql:27122: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "relation_id_pkey" for table "conformity_relation"
psql:_install.sql:27136: NOTICE:  CREATE TABLE will create implicit sequence
"custom_category_custom_category_id_seq" for serial column
"custom_category.custom_category_id"
psql:_install.sql:27136: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "custom_category_pkey" for table "custom_category"
psql:_install.sql:27226: NOTICE:  CREATE TABLE will create implicit sequence
"inspire_category_inspire_category_id_seq" for serial column
"inspire_category.inspire_category_id"
psql:_install.sql:27226: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "inspire_category_pkey" for table "inspire_category"
psql:_install.sql:27545: NOTICE:  view "search_wms_view" does not exist,
skipping
psql:_install.sql:27560: NOTICE:  view "search_wfs_view" does not exist,
skipping
psql:_install.sql:27602: NOTICE:  CREATE TABLE will create implicit sequence
"content_metadata_metadata_id_seq" for serial column
"content_metadata.metadata_id"
psql:_install.sql:27602: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "metadata_pkey" for table "content_metadata"
psql:_install.sql:27602: NOTICE:  CREATE TABLE / UNIQUE will create implicit
index "metadata_uuid_key" for table "content_metadata"
psql:_install.sql:27667: NOTICE:  function
f_collect_searchtext_wmc(pg_catalog.varchar) does not exist, skipping
psql:_install.sql:27668: NOTICE:  function
f_collect_topic_cat_wmc(pg_catalog.varchar) does not exist, skipping
psql:_install.sql:27834: NOTICE:  view "search_wmc_view" does not exist,
skipping
psql:_install.sql:27882: NOTICE:  CREATE TABLE / UNIQUE will create implicit
index "layer_preview_fkey_layer_id_key" for table "layer_preview"
psql:_install.sql:27894: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "termsofuse_pkey" for table "termsofuse"
psql:_install.sql:28092: NOTICE:  CREATE TABLE will create implicit sequence
"datalink_datalink_id_seq" for serial column "datalink.datalink_id"
psql:_install.sql:28092: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "pk_datalink_id" for table "datalink"
psql:_install.sql:28110: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "pk_datalink_keyword" for table "datalink_keyword"
psql:_install.sql:28282: NOTICE:  CREATE TABLE / UNIQUE will create implicit
index "wmc_fkey_layer_id_key" for table "wmc_preview"
psql:_install.sql:30593: NOTICE:  CREATE TABLE will create implicit sequence
"mb_role_role_id_seq" for serial column "mb_role.role_id"
psql:_install.sql:30593: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "role_id" for table "mb_role"
psql:_install.sql:30611: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create
implicit index "pk_fkey_mb_user_mb_group_id" for table "mb_user_mb_group"
psql:_install.sql:30652: NOTICE:  drop cascades to constraint
ows_relation_metadata_fkey_metadata_id_fkey on table ows_relation_metadata
psql:_install.sql:30707: NOTICE:  CREATE TABLE will create implicit sequence
"mb_metadata_metadata_id_seq" for serial column "mb_metadata.metadata_id"
psql:_install.sql:30707: ERROR:  function ndims(geometry) does not exist
HINT:  No function matches the given name and argument types. You might need
to add explicit type casts.
psql:_install.sql:30728: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30741: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30773: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30774: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30775: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30776: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30777: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30816: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:30908: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:31278: NOTICE:  function
f_count_layer_couplings(pg_catalog.int4) does not exist, skipping
psql:_install.sql:31516: NOTICE:  CREATE TABLE will create implicit sequence
"scheduler_scheduler_id_seq" for serial column "scheduler.scheduler_id"
psql:_install.sql:31516: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "pk_scheduler_id" for table "scheduler"
psql:_install.sql:31611: ERROR:  relation "ows_relation_metadata" does not
exist
psql:_install.sql:31648: ERROR:  relation "mb_metadata" does not exist
psql:_install.sql:31650: ERROR:  relation "ows_relation_metadata" does not
exist
psql:_install.sql:31652: ERROR:  relation "ows_relation_metadata" does not
exist
LINE 1: UPDATE ows_relation_metadata SET relation_type = origin FROM...



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Postgresql-Errors-during-installation-trunk-version-tp5047553p5047561.html
Sent from the mapbender-users mailing list archive at Nabble.com.

More information about the Mapbender_users mailing list