notification_type__new
is one of the duplicate errors.
[ewolfram@rhumba postgresql]$ find /web/mytlc -type f -name "*.sql" | xargs grep \
notification_type__new
Okay, now almost ever file below corrisponds to an application that is broken on the site...all those apps are choking on "notification::display::request_widget". I'm in way over my head here because I never used a database like this before...so I'm going to each of those directories and running the drop script that go with the ones mentioned in these errors.
/web/mytlc/packages/bug-tracker/sql/postgresql/bug-tracker-notifications-init.sql\
: v_foo:= notification_type__new (
/web/mytlc/packages/bug-tracker/sql/postgresql/bug-tracker-notifications-init.sql\
: v_foo:= notification_type__new (
/web/mytlc/packages/forums/sql/postgresql/forums-notifications-init.sql: v\
_foo:= notification_type__new (
/web/mytlc/packages/forums/sql/postgresql/forums-notifications-init.sql: v\
_foo:= notification_type__new (
/web/mytlc/packages/lars-blogger/sql/postgresql/notifications-init.sql: v_\
foo:= notification_type__new (
/web/mytlc/packages/notifications/sql/postgresql/notifications-package-create.sql\
:select define_function_args ('notification_type__new','type_id,sc_impl_id,short_\
name,pretty_name,description,creation_date,creation_user,creation_ip,context_id')\
;
/web/mytlc/packages/notifications/sql/postgresql/notifications-package-create.sql\
:create function notification_type__new (integer,integer,varchar,varchar,varchar,\
timestamp,integer,varchar,integer)
/web/mytlc/packages/notifications/sql/postgresql/notifications-package-drop.sql:d\
rop function notification_type__new (integer,varchar,varchar,varchar,timestamp,in\
teger,varchar,integer);
/web/mytlc/packages/survey/sql/postgresql/survey-notifications-init.sql: v\
_foo:= notification_type__new (
