DECLARE copy_id todolist_container.id%TYPE;
BEGIN
- INSERT INTO todolist_container (name, description, state) (
- SELECT 'Copy of ' || name, description, 'draft'
+ INSERT INTO todolist_container (name, description, state, create_uid) (
+ SELECT 'Copy of ' || name, description, 'draft', create_uid
FROM todolist_container
WHERE id = id_container
);
SELECT currval(pg_get_serial_sequence('todolist_container', 'id')) INTO copy_id;
- INSERT INTO todolist_task (name, description, container_id, milestone, planned, manday, priority) (
- SELECT name, description, copy_id, milestone, planned, manday, priority
+ INSERT INTO todolist_task (name, description, container_id, milestone, planned, manday, priority, create_uid) (
+ SELECT name, description, copy_id, milestone, planned, manday, priority, create_uid
FROM todolist_task
WHERE container_id = id_container
);