> > 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 <|/dumpfile/| > > > > 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. > > Split where? Dabase is very small. I open the dump file and with Ctrl X and Ctrl V I create 2 news files. Than run in order each file. > Is this function being used in a TRIGGER on esp_altera_estoque? yes Thank You Adrian and list!
