Wed Jul 21 23:09:02 PDT 2010
- Previous message: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8
- Next message: [Slony1-general] replication through slony beween the nodes having different versions of postgres
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All I got the problem in my database. The result of below queries in the database gives the following results : SELECT tgrelid,tgname,tgfoid from pg_trigger; tgrelid | tgname | tgfoid --------- +-------------------------------------------- +-------- 16470 | _clustername_denyaccess_1 | 19119 16470 | user_defined_trig_1 | 17733 16470 | user_defined_trig_2 | 17629 16392 | _cluastername_denyaccess_1 | 20801 msw=# SELECT relname from pg_class where oid=16470; relname ---------------- abc_pkey (1 row) msw=# SELECT relname from pg_class where oid=16392; relname ----------- abc (1 row) The result is like this for all the replicable tables i.e the denyaccess trigger is applied on the table as well as table_pkey with Different function ids (19119 and 20801 in this case). While function with oid 20801 is available in pg_proc table and the corresponding function name is denyaccess( ) but function with oid 19119 is not available In database and that's why the error "cache lookup failed for function 19119" Now my question is " how denyaccess trigger got applied on table_pkey" while denyaccess trigger should have been applied only on table name and user defined triggers should have been applied on table_pkey in slave database. What can lead to this kind of situation. Please help Thanks.. Tamanna ________________________________ From: tamanna madaan Sent: Thursday, July 15, 2010 5:47 PM To: 'slony1-general at lists.slony.info' Subject: "cache lookup failed for function 19119" error Hi All I am using slony-1.1.5 with postgres-8.1.2 . Everything was going fine earlier . But I am getting the following error for a while now while updating any of my tables : "cache lookup failed for function 19119". Can anyone please let me know if its something related to slony ?? Which function its talking about ?? Can dropping/recreating schema used by slony lead to this error in someway ?? Please help... Thanks.. Tamanna -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100722/19d2e1da/attachment.htm
- Previous message: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8
- Next message: [Slony1-general] replication through slony beween the nodes having different versions of postgres
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list