At 04:11 PM 12/8/2010, Coxen, Dayle wrote:
Now I really show my inexperience with R:Base...
When I replace the Build commands with Create (Below) I get:
-ERROR- Duplicate indexes are not allowed
INSERT INTO prod1a SELECT * FROM tmp1
INSERT INTO prod1a SELECT * FROM tmp2
DELETE ROWS FROM prod1a WHERE compsite IS NULL
DROP tempwrk
PROJECT tempwrk FROM workneed USING site compsite county
SECTION subsect BMP emp jobcode wp area bridge# finproj
DROP ckprod
CREATE INDEX site1 ON prod1a (compsite)
CREATE INDEX site2 ON tempwrk (compsite)
UNION prod1a WITH tempwrk FORMING ckprod
Dayle,
Good programming should always include the certainty of
DROPping the index first, before creating a new one. This
simple practice should eliminate the possibility of a
duplicate index.
The same practice should be followed when CREATing, DROPping,
and PROJECTing table(s), as well.
So, before CREATing a new index, you should always DROP
that index.
Example:
DROP INDEX indexname
CREATE INDEX indexname ....
Have fun!
Very Best R:egards,
Razzak.
