Hi all, I’m getting this error message when try to restore a database : ERROR: function f_validanumero_cnpj_cpf(character) does not exist LINE 1: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT (f_validanumero_cnpj_cpf(trim(cnpj_cpf)::char)=false) CONTEXT: função PL/pgSQL public.f_testacnpjcpf(character) linha 31 em IF COPY esp_altera_estoque, line 1, column nr_cnpjcpf: "24614011000120" The funny is that i’m restoring the database to the same Server. Steps: pg_dump dbname > dumpfile Create new database and restoring with: psql < Witch making mistakes do am i making? In this case, the database is small and if I open the dumpfile with a notepad and split in 2 files and run after other it works fine. -- Att Márcio A. Sepp |
