Hi José Pablo,
I've tried to upgrade imsld from version 0.1d to version 1.0d and got the following error (I'm using dotLRN 2.2.1-final on pg 8.1):
CONTEXT: sentencia SQL: create rule imsld_send_mail_data_r as on insert to imsld_send_mail_datai do instead (
update cr_dummy set val = (
select content_revision__new(
new.title,
new.description,
now(),
new.mime_type,
new.nls_language,
case when new.text is null
then new.data
else new.text
end,
content_symlink__resolve(new.item_id),
new.revision_id,
now(),
new.creation_user,
new.creation_ip,
new.object_package_id
));
insert into imsld_send_mail_data ( data_id, role_id, mail_data ) values (cr_dummy.val, new.role_id, new.mail_data); );
PL/pgSQL function "content_type__refresh_trigger" line 73 at execute statement
sentencia SQL: SELECT content_type__refresh_trigger( $1 )
PL/pgSQL function "content_type__refresh_view" line 105 at perform
sentencia SQL: SELECT content_type__refresh_view( $1 )
PL/pgSQL function "content_type__drop_attribute" line 42 at perform
CONTEXT: sentencia SQL: create rule imsld_send_mail_services_r as on insert to imsld_send_mail_servicesi do instead (
update cr_dummy set val = (
select content_revision__new(
new.title,
new.description,
now(),
new.mime_type,
new.nls_language,
case when new.text is null
then new.data
else new.text
end,
content_symlink__resolve(new.item_id),
new.revision_id,
now(),
new.creation_user,
new.creation_ip,
new.object_package_id
));
insert into imsld_send_mail_services ( mail_id, service_id, recipients, is_visible_p, parameters, username_property_id ) values (cr_dummy.val, new.service_id, new.recipients, new.is_visible_p, new.parameters, new.username_property_id); );
PL/pgSQL function "content_type__refresh_trigger" line 73 at execute statement
sentencia SQL: SELECT content_type__refresh_trigger( $1 )
PL/pgSQL function "content_type__refresh_view" line 105 at perform
sentencia SQL: SELECT content_type__refresh_view( $1 )
PL/pgSQL function "content_type__drop_attribute" line 42 at perform
CONTEXT: sentencia SQL: create rule imsld_send_mail_services_r as on insert to imsld_send_mail_servicesi do instead (
update cr_dummy set val = (
select content_revision__new(
new.title,
new.description,
now(),
new.mime_type,
new.nls_language,
case when new.text is null
then new.data
else new.text
end,
content_symlink__resolve(new.item_id),
new.revision_id,
now(),
new.creation_user,
new.creation_ip,
new.object_package_id
));
insert into imsld_send_mail_services ( mail_id, service_id, recipients, is_visible_p, parameters ) values (cr_dummy.val, new.service_id, new.recipients, new.is_visible_p, new.parameters); );
PL/pgSQL function "content_type__refresh_trigger" line 73 at execute statement
sentencia SQL: SELECT content_type__refresh_trigger( $1 )
PL/pgSQL function "content_type__refresh_view" line 105 at perform
sentencia SQL: SELECT content_type__refresh_view( $1 )
PL/pgSQL function "content_type__drop_attribute" line 42 at perform
psql:../imsld-level-c-create.sql:47: ERROR: la relacin t_imsld_rar_seq ya existe
psql:../imsld-level-c-create.sql:49: ERROR: la relacin imsld_rar_seq ya existe
psql:../imsld-level-c-create.sql:64: ERROR: la relacin imsld_runtime_activities_rels ya existe
