geuma / pDLNA

perl DLNA MediaServer
https://www.pdlna.org
GNU General Public License v3.0
30 stars 8 forks source link

PostgreSQL: NOTICE messages when initializing database #28

Open geuma opened 10 years ago

geuma commented 10 years ago

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"