Mon Aug 13 09:40:43 PDT 2007
- Previous message: [Slony1-general] cannot drop tables from schema after dropping tables from replication
- Next message: [Slony1-general] cannot drop tables from schema after dropping tables from replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Sorry, I think we're not on the same page re. this issue. > The *right* way to drop a table from replication is to first of all > run the slonik "SET DROP TABLE" command against the table. > I have in fact run SET DROP TABLE on the table prior to attempting to drop the table from schema. The table (new_gm_qm_set) doesn't show up in sl_table: mydb=# select * from _myslony.sl_table where tab_relname = 'new_gm_qm_set'; tab_id | tab_reloid | tab_relname | tab_nspname | tab_set | tab_idxname | tab_altered | tab_comment --------+------------+-------------+-------------+--------- +-------------+-------------+------------- (0 rows) > When that is processed, on the origin, the "logtrigger" trigger gets > removed. > When that is processed, on subscribers, the "denyaccess" trigger gets > removed, and the constraints get fixed up. > The logtrigger on the desired table for deletion (new_gm_qm_set ) is already gone: mydb=# \d new_gm_qm_set; Table "public.new_gm_qm_set" Column | Type | Modifiers ----------------+--------- +------------------------------------------------------------ id | integer | not null default nextval ('new_gm_qm_set_id_seq'::regclass) owner | integer | [blah blah blah...] Indexes: "new_gm_qm_set_pkey" PRIMARY KEY, btree (id) Foreign-key constraints: "new_gm_qm_set_owner_fkey" FOREIGN KEY ("owner") REFERENCES m_user(id) However, when I go to delete my desired table (new_gm_qm_set), it complains about another table: mydb=# begin; alter table new_gm_qm_set drop constraint new_gm_qm_set_owner_fkey; BEGIN ERROR: "m_user_pkey" is an index --Richard
- Previous message: [Slony1-general] cannot drop tables from schema after dropping tables from replication
- Next message: [Slony1-general] cannot drop tables from schema after dropping tables from replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list