Fri Jun 30 10:40:16 PDT 2006
- Previous message: [Slony1-general] Having problem with initial copy
- Next message: [Slony1-general] Can't drop table for slave node --
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
This may or may not be related to my previous post about EXECUTE SCRIPT failing. On my slave nodes, I have a non-slonied table that references a table is being slonied. tmc=# \d research.run_market; Table "research.run_market" Column | Type | Modifiers -----------+---------------------- +----------------------------------------- mktid | integer | not null sig_sysid | integer | not null status | character varying(1) | not null default 'A'::character varying pos_sysid | integer | not null Indexes: "run_market_mktid_sig_pos_idx" UNIQUE, btree (mktid, sig_sysid, pos_sysid) "run_market_status" btree (status) Foreign-key constraints: "run_market_mktid_fkey" FOREIGN KEY (mktid) REFERENCES public.market(mktid) "run_market_pos_sysid_fkey" FOREIGN KEY (pos_sysid) REFERENCES public."system"("sysid") "run_market_sig_sysid_fkey" FOREIGN KEY (sig_sysid) REFERENCES public."system"("sysid") "run_market_status_fkey" FOREIGN KEY (status) REFERENCES public.status(code) Triggers: run_market_aft_ins_upd AFTER INSERT OR UPDATE ON run_market FOR EACH ROW EXECUTE PROCEDURE public.run_market_aft_ins_upd() The tables public.market and public."system" are being slonied. If I try to drop this table research.run_market, I get an error: > ERROR: "market_pkey" is an index How can I drop this table? ###################################################################### This e-mail is confidential and should not be redistributed or forwarded by the recipient. The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient or you have received this communication in error, please immediately notify us by telephone. Receipt by anyone other than the intended recipient is not a waiver of any work-product or, if applicable, attorney-client privilege. This e-mail does not constitute an offering of any security. Such an offering may only be made by means of a private placement memorandum or other disclosure document. Nothing in this e-mail constitutes investment advice. Past performance is not indicative of future results. All e-mail to and from Millburn Ridgefield Corporation and its affiliates is monitored, stored and made available to regulators if requested. ######################################################################
- Previous message: [Slony1-general] Having problem with initial copy
- Next message: [Slony1-general] Can't drop table for slave node --
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list