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

Armin Retterath armin.retterath at gmail.com
Wed Apr 17 03:08:19 PDT 2013 

Do you use microsoft windows?
 Am 17.04.2013 12:04 schrieb "leonidas" <leonidas_liakos at yahoo.gr>:

> 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.
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20130417/6833035a/attachment-0001.html>

More information about the Mapbender_users mailing list