... to drop tables before creating them ... %diff -c crc-multi.txt.orig crc-multi.txt *** crc-multi.txt.orig Fri Jun 30 13:24:01 2000 --- crc-multi.txt Fri Jun 30 13:24:38 2000 *************** *** 1,3 **** --- 1,17 ---- + DROP TABLE ndict2 ; + DROP TABLE ndict3 ; + DROP TABLE ndict4 ; + DROP TABLE ndict5 ; + DROP TABLE ndict6 ; + DROP TABLE ndict7 ; + DROP TABLE ndict8 ; + DROP TABLE ndict9 ; + DROP TABLE ndict10 ; + DROP TABLE ndict11 ; + DROP TABLE ndict12 ; + DROP TABLE ndict16 ; + DROP TABLE ndict32 ; + CREATE TABLE ndict2 ( url_id int4 DEFAULT 0 NOT NULL, word_id int4 DEFAULT 0 NOT NULL, Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org ______________ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]