Fiz assim pra funcionar nos dois (PG 8.x e 9.x): 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 t.tgname not like 'RI_%' AND r.relname not like 'pg_%' ORDER BY 1, 2;
2012/11/13 Alexsander Rosa <[email protected]> > ERRO: coluna t.tgisinternal não existe > LINE 3: WHERE r.relkind = 'r' AND NOT t.tgisinternal > > > > 2012/11/13 Matheus de Oliveira <[email protected]> > >> >> >> 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 >> >> > > > -- > Atenciosamente, > Alexsander da Rosa > > > -- Atenciosamente, Alexsander da Rosa
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
