details: https://code.openbravo.com/erp/devel/pi/rev/8b497714669e changeset: 35511:8b497714669e user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Mar 05 13:58:17 2019 +0100 summary: fixed bug 40317: can't restore pg dump of a retail instance
Added search_path to trunc functions, which where missing in fix for #38179. This is necessary to enable pg_restore when trunc is used in a contraint or index as it calls other functions not in pg_catalog schema. diffstat: src-db/database/model/prescript-PostgreSql.sql | 16 ++++++++++++---- 1 files changed, 12 insertions(+), 4 deletions(-) diffs (47 lines): diff -r 2f46504e585b -r 8b497714669e src-db/database/model/prescript-PostgreSql.sql --- a/src-db/database/model/prescript-PostgreSql.sql Tue Feb 19 15:35:08 2019 +0530 +++ b/src-db/database/model/prescript-PostgreSql.sql Tue Mar 05 13:58:17 2019 +0100 @@ -735,7 +735,9 @@ date, varchar ) -RETURNS DATE AS ' +RETURNS DATE +SET SEARCH_PATH FROM CURRENT +AS ' DECLARE p_transformation VARCHAR; BEGIN @@ -768,7 +770,9 @@ timestamp with time zone, varchar ) -RETURNS DATE AS ' +RETURNS DATE +SET SEARCH_PATH FROM CURRENT +AS ' DECLARE p_transformation VARCHAR; BEGIN @@ -800,7 +804,9 @@ ( timestamp ) -RETURNS DATE AS ' +RETURNS DATE +SET SEARCH_PATH FROM CURRENT +AS ' BEGIN RETURN to_timestamp(to_char($1, dateFormat()), dateFormat()); END; @@ -811,7 +817,9 @@ ( timestamp with time zone ) -RETURNS DATE AS ' +RETURNS DATE +SET SEARCH_PATH FROM CURRENT +AS ' BEGIN RETURN to_timestamp(to_char($1, dateFormat()), dateFormat()); END; _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
