Muito Obrigado Emerson! att Fernando de Oliveira
From: [email protected] Date: Fri, 29 Jul 2011 09:54:15 -0300 Subject: Função para ajudar no problema da restauração do Backup To: [email protected] Olá Fernando. Cria essa funcão no teu servidor postgres -- Function: updatesequences() -- DROP FUNCTION updatesequences(); CREATE OR REPLACE FUNCTION updatesequences() RETURNS character varying AS$BODY$declare seqrecord record; maxrecord record; maxvalue integer;begin for seqrecord in select relname,split_part(relname,'_id_seq',1) tabela, 'id' coluna from pg_statio_user_sequences where relname not like 'audit_log_%' and relname not like 'auth_%' and relname not like 'django_%' Loop for maxrecord in execute 'select max(id) as f1 from ' || seqrecord.tabela LOOP maxvalue:=maxrecord.f1; end loop; execute 'alter sequence ' || seqrecord.relname || ' restart with ' || coalesce(maxvalue,0)+1 ; End LOOP; return 1;end$BODY$ LANGUAGE plpgsql VOLATILE COST 100;ALTER FUNCTION updatesequences() OWNER TO postgres; Executa assim - Select updatesequences(); Emerson MartinsDBA JrItec/AL82 9123-5504 82 9668-1283
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
