From: | "Fabio Arias" <fharias(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Español Ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | ERROR ADD TABLE SET REPLICACION |
Date: | 2008-11-05 16:21:45 |
Message-ID: | c1d7f0f90811050821q6fa685co67911c5c5909564e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Muy buenos dias Listeros, tengo un caso extraño con la replicacion cuando
intento agregar una tabla a un SET me ocurre este error. Que puedo hacer
para resolverlo gracias,
An error has occurred:
ERROR: permission denied for relation pg_class
CONTEXT: SQL statement "select T.tab_reloid, T.tab_set, T.tab_idxname,
T.tab_altered, S.set_origin, PGX.indexrelid,
"_cluster_replicacion_cbctso".slon_quote_brute(PGN.nspname) || '.' ||
"_cluster_replicacion_cbctso".slon_quote_brute(PGC.relname) as tab_fqname
from "_cluster_replicacion_cbctso".sl_table T,
"_cluster_replicacion_cbctso".sl_set S, "pg_catalog".pg_class PGC,
"pg_catalog".pg_namespace PGN, "pg_catalog".pg_index PGX,
"pg_catalog".pg_class PGXC where T.tab_id = $1 and T.tab_set = S.set_id
and T.tab_reloid = PGC.oid and PGC.relnamespace = PGN.oid and PGX.indrelid =
T.tab_reloid and PGX.indexrelid = PGXC.oid and PGXC.relname = T.tab_idxname
for update"
PL/pgSQL function "altertableforreplication" line 25 at SQL statement
SQL statement "SELECT
"_cluster_replicacion_cbctso".alterTableForReplication( $1 )"
PL/pgSQL function "setaddtable_int" line 109 at perform
SQL statement "SELECT "_cluster_replicacion_cbctso".setAddTable_int( $1 ,
$2 , $3 , $4 , $5 )"
PL/pgSQL function "setaddtable" line 37 at perform
--
Fabio Hernando Arias Vera
Cel. 314 411 7776
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel R. Bercián | 2008-11-05 17:23:12 | Re: Ayuda PostgreSQL |
Previous Message | Edwin Quijada | 2008-11-05 16:21:24 | RE: Convertir numero a HH:MM |