ERROR ADD TABLE SET REPLICACION

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

Responses

Browse pgsql-es-ayuda by date

  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