search

kombat003 / trader-dss

Automatically exported from code.google.com/p/trader-dss
0 stars 0 forks source link

lots of the tables with symb in them don't have exch #43

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Will need something like this done to cart, trades, watch

alter table cart add column exch character varying(6);
update cart set exch = 'L';
alter table cart alter column exch set NOT NULL;
alter table cart drop  CONSTRAINT cart_pkey ;
alter table cart add constraint cart_pkey PRIMARY KEY (pfid, symb, exch, date);
ALTER TABLE ONLY cart ADD CONSTRAINT constraint_stocks FOREIGN KEY (symb,
exch) REFERENCES stocks(symb, exch) MATCH FULL;

Original issue reported on code.google.com by peter.st...@1ab.ltd.uk on 8 Feb 2010 at 2:04

GoogleCodeExporter commented 8 years ago 
Bum! They don't need exch because a portfolio can only have one exchange!

Original comment by peter.st...@1ab.ltd.uk on 8 Feb 2010 at 2:13