Skip to content

PostgreSQL: NOTICE messages when initializing database #28

@geuma

Description

@geuma

When a PostgreSQL database is used as a backend for pDLNA, various NOTICE messages will appear. This messages are only informing about some tables or primary keys, which have been created by pDLNA.

it might look like:
root@mediaserver:~# /etc/init.d/pdlna start
Starting pDLNA ...
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "metadata_pkey" for table "metadata"
NOTICE: CREATE TABLE will create implicit sequence "items_id_seq" for serial column "items.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "items_pkey" for table "items"
NOTICE: CREATE TABLE will create implicit sequence "device_ip_id_seq" for serial column "device_ip.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "device_ip_pkey" for table "device_ip"
NOTICE: CREATE TABLE will create implicit sequence "device_bm_id_seq" for serial column "device_bm.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "device_bm_pkey" for table "device_bm"
NOTICE: CREATE TABLE will create implicit sequence "device_udn_id_seq" for serial column "device_udn.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "device_udn_pkey" for table "device_udn"
NOTICE: CREATE TABLE will create implicit sequence "device_nts_id_seq" for serial column "device_nts.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "device_nts_pkey" for table "device_nts"
NOTICE: CREATE TABLE will create implicit sequence "device_service_id_seq" for serial column "device_service.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "device_service_pkey" for table "device_service"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stat_mem_pkey" for table "stat_mem"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stat_items_pkey" for table "stat_items"

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions