Using 1.1.1 RC5, I added a new license template and then executed the folowing
command and received the following error:
r...@rh licenses]# /usr/bin/fossinit `pwd`
Applying database schema
--------
SQL failed: SELECT class.relname AS table,
attr.attnum AS ordinal,
attr.attname AS column_name,
type.typname AS type,
attr.atttypmod-4 AS modifier,
attr.attnotnull AS notnull,
attrdef.adsrc AS default,
col_description(attr.attrelid, attr.attnum) AS description
FROM pg_class AS class
INNER JOIN pg_attribute AS attr ON attr.attrelid = class.oid
AND attr.attnum > 0
INNER JOIN pg_type AS type ON attr.atttypid = type.oid
INNER JOIN information_schema.tables AS tab ON class.relname =
tab.table_name
AND tab.table_type = 'BASE TABLE'
AND tab.table_schema = 'public'
LEFT OUTER JOIN pg_attrdef AS attrdef ON adrelid = attrelid
AND adnum = attnum
ORDER BY class.relname,attr.attnum;
--------
SQL failed: SELECT viewname,definition FROM pg_views WHERE viewowner = 'fossy';
--------
SQL failed: SELECT relname
FROM pg_class
WHERE relkind = 'S'
AND relnamespace IN (
SELECT oid
FROM pg_namespace
WHERE nspname NOT LIKE 'pg_%'
AND nspname != 'information_schema'
);
--------
SQL failed: SELECT c.conname AS constraint_name,
CASE c.contype
WHEN 'c' THEN 'CHECK'
WHEN 'f' THEN 'FOREIGN KEY'
WHEN 'p' THEN 'PRIMARY KEY'
WHEN 'u' THEN 'UNIQUE'
END AS type,
CASE WHEN c.condeferrable = 'f' THEN 0 ELSE 1 END AS is_deferrable,
CASE WHEN c.condeferred = 'f' THEN 0 ELSE 1 END AS is_deferred,
t.relname AS table_name, array_to_string(c.conkey, ' ') AS
constraint_key,
CASE confupdtype
WHEN 'a' THEN 'NO ACTION'
WHEN 'r' THEN 'RESTRICT'
WHEN 'c' THEN 'CASCADE'
WHEN 'n' THEN 'SET NULL'
WHEN 'd' THEN 'SET DEFAULT'
END AS on_update,
CASE confdeltype
WHEN 'a' THEN 'NO ACTION'
WHEN 'r' THEN 'RESTRICT'
WHEN 'c' THEN 'CASCADE'
WHEN 'n' THEN 'SET NULL'
WHEN 'd' THEN 'SET DEFAULT' END AS on_delete, CASE confmatchtype
WHEN 'u' THEN 'UNSPECIFIED'
WHEN 'f' THEN 'FULL'
WHEN 'p' THEN 'PARTIAL'
END AS match_type,
t2.relname AS references_table,
array_to_string(c.confkey, ' ') AS fk_constraint_key
FROM pg_constraint AS c
LEFT JOIN pg_class AS t ON c.conrelid = t.oid
INNER JOIN information_schema.tables AS tab ON t.relname =
tab.table_name
LEFT JOIN pg_class AS t2 ON c.confrelid = t2.oid
ORDER BY constraint_name,table_name;
--------
SQL failed: SELECT tablename AS table, indexname AS index, indexdef AS define
FROM pg_indexes
INNER JOIN information_schema.tables ON table_name = tablename
AND table_type = 'BASE TABLE'
AND table_schema = 'public'
AND schemaname = 'public'
ORDER BY tablename,indexname;
--------
SQL failed: CREATE SEQUENCE "agent_agent_pk_seq" START 1;
[r...@rhle51x86 licenses]#
Any help is greatly appreciated. Thanks.
_______________________________________________
fossology mailing list
[email protected]
http://fossology.org/mailman/listinfo/fossology
