On Tue, Nov 13, 2012 at 1:21 PM, Alexsander Rosa <[email protected]>wrote:
> Num PG8: > ERROR: function pg_catalog.pg_get_triggerdef(oid, boolean) does not exist > LINHA 1: SELECT r.relname AS tblname, t.tgname, pg_catalog.pg_get_tri... > ^ > DICA: No function matches the given name and argument types. You might > need to add explicit type casts. > > > Simples, é só tirar o segundo parâmetro na chamada da função: SELECT r.relname AS tblname, t.tgname, pg_catalog.pg_get_triggerdef(t.oid) AS tgdef, t.tgenabled FROM pg_catalog.pg_class r INNER JOIN pg_catalog.pg_trigger t ON r.oid = t.tgrelid WHERE r.relkind = 'r' AND NOT t.tgisinternal ORDER BY 1, 2; > > Em 13 de novembro de 2012 12:37, Fabrízio de Royes Mello < > [email protected]> escreveu: > >> >> Em 13 de novembro de 2012 12:34, Alexsander Rosa < >> [email protected]> escreveu: >> >> E abaixo da versão 9, tem alguma forma? >>> >>> >> Alexsander, >> >> O Matheus respondeu essa pergunta: >> >> >> http://listas.postgresql.org.br/pipermail/pgbr-geral/2012-November/033438.html >> >> Att, >> >> -- >> Fabrízio de Royes Mello >> Consultoria/Coaching PostgreSQL >> >> Blog sobre TI: http://fabriziomello.blogspot.com >> >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> >> Twitter: http://twitter.com/fabriziomello >> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > > -- > Atenciosamente, > Alexsander da Rosa > > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Matheus de Oliveira Analista de Banco de Dados PostgreSQL Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
