Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for schema logradouro LINE 1: ...ino AS D ON N.id_destino = D.id_destino LEFT JOIN logradouro... ^ in /home/storage/2/e8/52/confecon/public_html/library/db.php on line 160
ERROR: permission denied for schema logradouro LINE 1: ...ino AS D ON N.id_destino = D.id_destino LEFT JOIN logradouro... ^ERRO NA QUERY =>>>> select N.nm_titulo_noticia,to_char(N.dt_publicacao,'DD/MM/YYYY') as datapublicacao_noticia,SUBSTRING(N.cd_noticia,1,4) as projeto, uf.id_uf from gagenciaradio.noticia AS N LEFT JOIN gagenciaradio.destino AS D ON N.id_destino = D.id_destino LEFT JOIN logradouro.log_uf as uf ON N.id_uf = uf.id_uf LEFT JOIN gagenciaradio.projeto AS P ON SUBSTRING(N.cd_noticia,1,4) = P.cd_projeto where N.cd_noticia LIKE 'COFE170023'
Result=
164