Backlog Courrier

en migrant la base 1904 en 2003, on obtient les erreurs ci-dessous. Pour la migration, la doc suivante a été utilisée:
https://docs.maarch.org/gitbook/html/MaarchCourrier/20.03/guat/guat_migration/home.html

postgres@henri-ThinkPad-T480s:/home/henri/Downloads$ psql -d testicdc2 < /var/www/html/maarch2003/migration/20.03/2003.sql
ERROR:  relation "parameters" does not exist
LINE 1: UPDATE parameters SET param_value_string = '20.03' WHERE id ...
               ^
ERROR:  relation "parameters" does not exist
LINE 1: UPDATE parameters SET description = 'Département par défaut ...
               ^
NOTICE:  view "res_view_letterbox" does not exist, skipping
DROP VIEW
NOTICE:  view "res_view_attachments" does not exist, skipping
DROP VIEW
NOTICE:  view "view_folders" does not exist, skipping
DROP VIEW
NOTICE:  view "res_view_business" does not exist, skipping
DROP VIEW
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "docservers" does not exist
LINE 2: DELETE FROM docservers where docserver_type_id = 'FULLTEXT';
                    ^
ERROR:  relation "docservers" does not exist
LINE 1: INSERT INTO docservers (docserver_id, docserver_type_id, dev...
                    ^
ERROR:  relation "docservers" does not exist
LINE 1: INSERT INTO docservers (docserver_id, docserver_type_id, dev...
                    ^
ERROR:  relation "docserver_types" does not exist
LINE 1: UPDATE docserver_types SET fingerprint_mode = NULL WHERE doc...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET fulltext_result = 'SUCCESS' WHERE f...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET fulltext_result = 'ERROR' WHERE ful...
               ^
ERROR:  relation "res_attachments" does not exist
LINE 1: UPDATE res_attachments SET fulltext_result = 'SUCCESS' WHERE...
               ^
ERROR:  relation "res_attachments" does not exist
LINE 1: UPDATE res_attachments SET fulltext_result = 'ERROR' WHERE f...
               ^
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'processDocument'
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'viewDoc'
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event = 'signatureBookAction'
               ^
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
ERROR:  relation "groupbasket" does not exist
LINE 1: update groupbasket set list_event_data = '{"canUpdate":true,...
               ^
ERROR:  relation "groupbasket" does not exist
LINE 1: UPDATE groupbasket SET list_event_data = '{"defaultTab":"inf...
               ^
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id in (SELECT id...
                    ^
ERROR:  relation "actions_groupbaskets" does not exist
LINE 1: DELETE FROM actions_groupbaskets WHERE id_action in (SELECT ...
                    ^
ERROR:  relation "groupbasket_redirect" does not exist
LINE 1: DELETE FROM groupbasket_redirect WHERE action_id in (SELECT ...
                    ^
ERROR:  relation "actions" does not exist
LINE 1: DELETE FROM actions WHERE component = 'viewDoc' OR action_pa...
                    ^
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'rejectVisaBackToPreviousActi...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'redirectInitiatorEntityActio...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'rejectVisaBackToPreviousActi...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'resetVisaAction' WHERE actio...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'interruptVisaAction' WHERE a...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendSignatureBookAction' WHE...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'continueVisaCircuitAction' W...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'closeMailWithAttachmentsOrNo...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendToOpinionCircuitAction' ...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'continueOpinionCircuitAction...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'giveOpinionParallelAction' W...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'sendToParallelOpinion' WHERE...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'validateParallelOpinionDiffu...
               ^
ERROR:  relation "actions" does not exist
LINE 1: UPDATE actions SET component = 'createAcknowledgementReceipt...
               ^
ERROR:  relation "actions_groupbaskets" does not exist
LINE 1: DELETE FROM actions_groupbaskets WHERE id_action IN (SELECT ...
                    ^
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id IN (SELECT id...
                    ^
ERROR:  relation "actions" does not exist
LINE 1: DELETE FROM actions WHERE action_page = 'put_in_copy';
                    ^
ERROR:  relation "folders" does not exist
CONTEXT:  SQL statement "ALTER TABLE folders RENAME TO folder_tmp"
PL/pgSQL function inline_code_block line 3 at SQL statement
NOTICE:  table "folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE folders
                     ^
NOTICE:  table "resources_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE resources_folders
                     ^
NOTICE:  table "entities_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE entities_folders
                     ^
NOTICE:  table "users_pinned_folders" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE users_pinned_folders
                     ^
NOTICE:  table "custom_fields" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE custom_fields
                     ^
NOTICE:  table "contacts_custom_fields_list" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts_custom_fields_list
                     ^
NOTICE:  table "indexing_models" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE indexing_models
                     ^
NOTICE:  table "indexing_models_fields" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE indexing_models_fields
                     ^
ERROR:  relation "tags" does not exist
CONTEXT:  SQL statement "ALTER TABLE tags RENAME COLUMN tag_label TO label"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "tags" does not exist
LINE 1: SELECT setval('tags_id_seq', (SELECT MAX(id) from tags));
                                                          ^
NOTICE:  table "tags_entities" does not exist, skipping
DROP TABLE
ERROR:  relation "doctypes" does not exist
CONTEXT:  SQL statement "ALTER TABLE doctypes ADD COLUMN process_delay INTEGER"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "notes" does not exist
CONTEXT:  SQL statement "ALTER TABLE notes ADD COLUMN user_tmp_id integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_attachments RENAME COLUMN doc_date TO modification_date"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_attachments" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_attachments ADD COLUMN modified_by integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "docservers" does not exist
LINE 2: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET coll_id = 'attachments_coll', is_reado...
               ^
ERROR:  relation "docservers" does not exist
LINE 1: UPDATE docservers SET docserver_type_id = 'DOC' WHERE coll_i...
               ^
ERROR:  relation "res_letterbox" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_letterbox ADD COLUMN category_id character varying(32)"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET external_id = jsonb_set(external_id...
               ^
QUERY:  UPDATE res_letterbox SET external_id = jsonb_set(external_id, '{signatureBookId}', external_signatory_book_id::text::jsonb) WHERE external_signatory_book_id IS NOT NULL
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 2 WHERE category_id = 'o...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 3 WHERE category_id = 'i...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 4 WHERE category_id = 'g...
               ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox set model_id = 1 WHERE model_id IS NULL...
               ^
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
CONTEXT:  SQL statement "ALTER TABLE res_letterbox ADD COLUMN typist_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "usergroup_content" does not exist
CONTEXT:  SQL statement "ALTER TABLE usergroup_content ADD COLUMN user_id_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "usergroup_content" does not exist
CONTEXT:  SQL statement "ALTER TABLE usergroup_content ADD COLUMN group_id_tmp integer"
PL/pgSQL function inline_code_block line 3 at SQL statement
NOTICE:  table "contacts" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts
                     ^
NOTICE:  table "contacts_parameters" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE contacts_parameters
                     ^
ERROR:  relation "acknowledgement_receipts" does not exist
ERROR:  relation "acknowledgement_receipts" does not exist
ERROR:  relation "contacts_groups_lists" does not exist
ERROR:  relation "contacts_groups_lists" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
LINE 1: UPDATE adr_letterbox SET version = 1;
               ^
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "adr_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET version = 1;
               ^
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "entities" does not exist
ERROR:  relation "entities" does not exist
ERROR:  relation "usergroup_content" does not exist
LINE 1: DELETE FROM usergroup_content WHERE group_id in (SELECT id F...
                    ^
QUERY:  DELETE FROM usergroup_content WHERE group_id in (SELECT id FROM usergroups WHERE enabled = 'N')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "actions_categories" does not exist
LINE 1: DELETE FROM actions_categories WHERE action_id in (SELECT id...
                    ^
QUERY:  DELETE FROM actions_categories WHERE action_id in (SELECT id FROM actions WHERE enabled = 'N')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "listinstance" does not exist
LINE 1: UPDATE listinstance SET item_mode = 'cc' WHERE item_mode = '...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'admin_fi...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'put_doc_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'fileplan...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'update_c...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'join_res...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'join_res...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'close_ca...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_case...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id IN ('folder...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_tag_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'tag_view...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'thesauru...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'add_thes...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'manage_tags_app...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'update_status_m...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'quicklau...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'put_in_v...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'print_de...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'print_do...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'view_att...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'index_at...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'display_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'choose_e...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'manage_n...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'notes_re...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'graphics...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'show_rep...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'param_te...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'doctype_...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'search_c...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'use_date...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'delete_d...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'manage_numeric_...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_rec...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'update_l...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_rec...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET service_id = 'edit_resource' ...
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'edit_att...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'modify_a...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'delete_a...
                    ^
ERROR:  relation "usergroups_services" does not exist
ERROR:  relation "usergroups_services" does not exist
ERROR:  relation "usergroups_services" does not exist
LINE 1: UPDATE usergroups_services SET parameters = (
               ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'view_per...
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: INSERT INTO usergroups_services (group_id, service_id)
                    ^
ERROR:  relation "usergroups_services" does not exist
LINE 1: DELETE FROM usergroups_services WHERE service_id = 'admin_th...
                    ^
ERROR:  relation "history" does not exist
LINE 1: UPDATE history SET event_type = 'PRE' where event_type = 'RE...
               ^
ERROR:  relation "listmodels" does not exist
LINE 1: UPDATE listmodels SET title = object_id WHERE title IS NULL
               ^
QUERY:  UPDATE listmodels SET title = object_id WHERE title IS NULL
CONTEXT:  PL/pgSQL function inline_code_block line 6 at SQL statement
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = REGEXP_REPLACE(basket_cla...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = REGEXP_REPLACE(basket_cla...
               ^
ERROR:  relation "templates" does not exist
LINE 1: UPDATE templates SET template_target = 'attachments' WHERE (...
               ^
ERROR:  relation "templates" does not exist
LINE 1: UPDATE templates SET template_target = 'notes' WHERE (templa...
               ^
ERROR:  relation "templates" does not exist
LINE 1: DELETE FROM templates WHERE template_target = '' OR template...
                    ^
NOTICE:  table "list_templates" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE list_templates
                     ^
NOTICE:  table "list_templates_items" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE list_templates_items
                     ^
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "tags" does not exist
ERROR:  relation "priorities" does not exist
LINE 1: UPDATE priorities SET delays = 30 WHERE delays IS NULL;
               ^
ERROR:  relation "priorities" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "notif_email_stack" does not exist
ERROR:  relation "users" does not exist
LINE 1: UPDATE users SET status = 'SPD' WHERE enabled = 'N' and (sta...
               ^
QUERY:  UPDATE users SET status = 'SPD' WHERE enabled = 'N' and (status = 'OK' or status = 'ABS')
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "usergroups" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
ERROR:  relation "actions" does not exist
NOTICE:  view "fp_view_fileplan" does not exist, skipping
DROP VIEW
ERROR:  relation "res_attachments" does not exist
NOTICE:  table "foldertypes" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_doctypes" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_doctypes_level1" does not exist, skipping
DROP TABLE
NOTICE:  table "foldertypes_indexes" does not exist, skipping
DROP TABLE
ERROR:  relation "doctypes" does not exist
NOTICE:  table "mlb_doctype_ext" does not exist, skipping
DROP TABLE
ERROR:  relation "priorities" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "res_letterbox" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance" does not exist
ERROR:  relation "listinstance_history_details" does not exist
ERROR:  relation "usergroup_content" does not exist
ERROR:  relation "emails" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "res_attachments" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
ERROR:  relation "users" does not exist
NOTICE:  table "templates_doctype_ext" does not exist, skipping
DROP TABLE
NOTICE:  table "notif_rss_stack" does not exist, skipping
DROP TABLE
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET external_id = json_build_object('m2...
               ^
QUERY:  UPDATE res_letterbox SET external_id = json_build_object('m2m', reference_number), reference_number = null FROM mlb_coll_ext WHERE res_letterbox.res_id = mlb_coll_ext.res_id AND mlb_coll_ext.nature_id = 'message_exchange'
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "custom_fields" does not exist
ERROR:  relation "custom_fields" does not exist
LINE 1: INSERT INTO custom_fields (id, label, type, values) VALUES (...
                    ^
ERROR:  relation "custom_fields" does not exist
LINE 1: ...al('custom_fields_id_seq', (select max(id)+1 from custom_fie...
                                                             ^
ERROR:  relation "res_letterbox" does not exist
LINE 1: UPDATE res_letterbox SET custom_fields = json_build_object('...
               ^
QUERY:  UPDATE res_letterbox SET custom_fields = json_build_object('1', 'Courrier simple') FROM mlb_coll_ext WHERE res_letterbox.res_id = mlb_coll_ext.res_id AND mlb_coll_ext.nature_id = 'simple_mail'
CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets set basket_clause = replace(basket_clause, 'n...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = replace(basket_clause, 's...
               ^
ERROR:  relation "baskets" does not exist
LINE 1: UPDATE baskets SET basket_clause = replace(basket_clause, 'a...
               ^
ERROR:  relation "history" does not exist
LINE 1: UPDATE history SET user_id = (select user_id from users orde...
               ^
NOTICE:  table "users_followed_resources" does not exist, skipping
DROP TABLE
ERROR:  no schema has been selected to create in
LINE 1: CREATE TABLE users_followed_resources
                     ^
ERROR:  relation "shippings" does not exist
CONTEXT:  SQL statement "ALTER TABLE shippings DROP COLUMN IF EXISTS document_type"
PL/pgSQL function inline_code_block line 3 at SQL statement
ERROR:  relation "shippings" does not exist
ERROR:  relation "shippings" does not exist
ERROR:  relation "indexing_models" does not exist
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: INSERT INTO indexing_models (id, category, label, "default",...
                    ^
ERROR:  relation "indexing_models" does not exist
LINE 1: ...('indexing_models_id_seq', (select max(id)+1 from indexing_m...
                                                             ^
ERROR:  relation "indexing_models_fields" does not exist
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 2: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...
                    ^
ERROR:  relation "indexing_models_fields" does not exist
LINE 1: INSERT INTO indexing_models_fields (model_id, identifier, ma...