ERRO: coluna t.tgisinternal não existe LINE 3: WHERE r.relkind = 'r' AND NOT t.tgisinternal
2012/11/13 Matheus de Oliveira <matioli.math...@gmail.com> > > > On Tue, Nov 13, 2012 at 1:21 PM, Alexsander Rosa < > alexsander.r...@gmail.com> 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 < >> fabriziome...@gmail.com> escreveu: >> >>> >>> Em 13 de novembro de 2012 12:34, Alexsander Rosa < >>> alexsander.r...@gmail.com> 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 >>> pgbr-geral@listas.postgresql.org.br >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> >> -- >> Atenciosamente, >> Alexsander da Rosa >> >> >> >> _______________________________________________ >> pgbr-geral mailing list >> pgbr-geral@listas.postgresql.org.br >> 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 > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Atenciosamente, Alexsander da Rosa
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral