#...dbdef =-SVIZIR -Ucds -P@cds4Viz viz7@VIZIR ok not a XMM cat ====Catalog J/A+A/578/A45 already in VizieR-SVIZIR: J/A+A/578/A45|35780045|18|3|7 J/A+A/578/A45|35780045|18|4|7 J/A+A/578/A45|35780045|18|5|7 #===Items in list: 1 #...Popularity of catalog (J/A+A/578/A45): 1928 setUCD -raw /home/cats/J/A+A/578/A45/ReadMe > /tmp/viz37837.ucd CONFIRM /home/cats/bin/confirm_no.nostdin ====Visit the 108 UCDs (in /tmp/viz37837.ucd): [N] (set by default) ====Database chosen for J/A+A/578/A45 = viz7@VIZIR (from default dbdef) ....Cleaning the /home/cats/in/gl directory rm: No match. ....keeping the list of UCDs as /home/cats/in/gl/UCDs ....Executing (METADB=metaviz@VIZIR, input file=/home/cats/J/A+A/578/A45/ReadMe): (/usr/local/bin/vizin*) CONFIRM /home/cats/bin/confirm_yes.nostdin ----Executing vizin -confirm=y -popu 1928 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/A+A/578/A45/ReadMe [Y] (set by default) option confirm=y is set #... servername=cdsarc.u-strasbg.fr port=5432 dbase=vizier type=postgres (5) ---- 5 columns added from .status (0 VIRTUAL) ---- 6 columns (+1) added from .status (1 VIRTUAL) ---- 7 columns with LinkToNote ----There are 2 table/column(s) concerned by \vizSet ====There were 62 UCDs loaded from: /home/cats/in/gl/UCDs use dbname=viz7@VIZIR #...Change in METAtab(explain): => List of stars for groups 3-6 (tables 1-4) ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'List of stars for gro'... ----[vizier] Stat=0 from 'DROP table c35780045groups' #...Change in METAtab(explain): => Group 7: Serendipity and literature ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'Group 7: Serendipity '... ----[vizier] Stat=0 from 'DROP table c35780045t5' #...Change in METAtab(explain): => List of the E-BOSS release 2 bow-shock candidates (BSC) and corresponding stellar parameters ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'List of the E-BOSS re'... ----[vizier] Stat=0 from 'DROP table c35780045t6' #...Change in METAtab(explain): => Parameters of the bow-shock candidates and medium density ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'Parameters of the bow'... ----[vizier] Stat=0 from 'DROP table c35780045t7' #...Change in METAtab(explain): => Total list of bow-shock candidates of E-BOSS releases 1 and 2 ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'Total list of bow-sho'... ----[vizier] Stat=0 from 'DROP table c35780045t8' ----[vizier] Stat=0 from 'DELETE from METAqin where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAdig where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAsed where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAobj where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAtimerel where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAtimecol where catid = 35780045' ----[vizier] Stat=65 from 'DELETE from METAcol where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell00 where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAlaf where catid = 35780045' ----[vizier] Stat=1 from 'DELETE from METAkwd where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcro where catid = 35780045' ----[vizier] Stat=5 from 'DELETE from METAtab where catid = 35780045' ----[vizier] Stat=75 from 'DELETE from METAnot where catid = 35780045' ----[vizier] Stat=5 from 'DELETE from METAmor where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell02 where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell03 where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell09 where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell0a where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell0b where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell0c where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell0d where catid = 35780045' ----[vizier] Stat=0 from 'DELETE from METAcell0e where catid = 35780045' ****Error execute query: INSERT into METAcat( catid, kslot, status, catype, name, title, bibcode, authors, explain, popu, authid, flags, doi, orcid) VALUES ( 35780045, 255, 16, 0, 'J/A+A/578/A45', 'E-BOSS. II. Catalogue second release (Peri+, 2015)', '2015A&A...578A..45P', 'Peri C.S., Benaglia P., Isequilla N.L.', '', 1928, 0, 0, '', '') **** **** --POSTGRES MSG db=1 **** Report from: stdb_pg, Status: STDB_ERR ****ERROR: duplicate key value violates unique constraint "metacat_pkey" DETAIL: K ****ey (catid)=(35780045) already exists. ****ERROR: duplicate key value violates unique constraint "metacat_pkey" DETAIL: K ****ey (catid)=(35780045) already exists. ----[vizier] Stat=-1 from 'INSERT into METAcat( catid, kslot, status, catype, name'... ----[vizier] Stat=1 from 'Update METAcat set status = status | 16 Where catid = 3'... ----[vizier] Stat=0 from 'Update METAcol set morid = 8 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 9 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 6 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 35780045 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 7 Where catid = 35780045 and'... ----[vizier] Stat=1 from 'select add_adc('J/A+A/578/A45', 'Stars, early-type');' ----[vizier] Stat=1 from 'select add_adc('J/A+A/578/A45', 'Surveys');' ----[vizier] Stat=1 from 'select add_optical('J/A+A/578/A45');' INFO: ....set_kslot(1!): kslot was J/A+A/578/A45!; 18! keywords INFO: ----set_kslot(1!): kslot now J/A+A/578/A45!; 18! keywords ----[vizier] Stat=1 from 'select set_kslot('J/A+A/578/A45');' ----[vizier] Stat=1 from 'Update METAcat set catype = 2 Where catid = 35780045' ....\vizPosition{groups.dat}: \vizSimbad position from {${Name}} (precoo=6) .... Creating BCP file 'c35780045groups.bcp' (366 rows) 366 records. Histogram of Coordinate Precision (/home/cats/in/gl/c35780045groups.pos): -1 0 1 2 3 4 5 6 7 0 0 0 0 0 0 0 3 363 ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... #...Verify (RA, DE) index on 'J/A+A/578/A45/groups' (366 records) no! .... Creating BCP file 'c35780045t5.bcp' (45 rows) 45 records. ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... CONFIRM:set new ICRS position  <= [y] .... Creating BCP file 'c35780045t6.bcp' (45 rows) #The following operations were generated by vizin #From ReadMe: /home/cats/J/A+A/578/A45/ReadMe #Into METAdb: metaviz@VIZIR # datadb: viz7@VIZIR /*++++++++ Clean up for catalog: 35780045 --------*/ #tab#1 loadate=0496486137s(2015-09-25T08:48:57) J/A+A/578/A45/groups #tab#2 loadate=0496486137s(2015-09-25T08:48:57) J/A+A/578/A45/table5 #tab#3 loadate=0496486137s(2015-09-25T08:48:57) J/A+A/578/A45/table6 #tab#4 loadate=0496486137s(2015-09-25T08:48:57) J/A+A/578/A45/table7 #tab#5 loadate=0496486137s(2015-09-25T08:48:57) J/A+A/578/A45/table8 /*------Clean up META tables--------*/ #+++ Coordinates for groups.dat are COMPUTED: FK5 equinox=2000 #==> Coordinate System of table5.dat: FK5 equinox=2000 #==> Coordinate System of table6.dat: Galactic ++++increase the precision for computed column 5 ++++increase the precision for computed column 5 #...CooCompute icrs(Eq=2000, Ep=-nan) from: gal(Eq=-nan, Ep=-nan) [x1] ----[vizier] Stat=1 from 'Update METAcol set explain ='Right ascension (ICRS) '... ----[vizier] Stat=1 from 'Update METAcol set explain ='Declination (ICRS) '... 45 records. Histogram of Coordinate Precision: -1 0 1 2 3 4 5 6 7 0 0 0 0 45 0 0 0 0 ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... #...Verify (RA, DE) index on 'J/A+A/578/A45/table6' (45 records) no! .... Creating BCP file 'c35780045t7.bcp' (39 rows) 39 records. ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ....\vizPosition{table8.dat}{file=table8.sim} (precoo=6) .... Creating BCP file 'c35780045t8.bcp' (73 rows) 73 records. Histogram of Coordinate Precision (/home/cats/in/gl/c35780045t8.pos): -1 0 1 2 3 4 5 6 7 0 0 0 0 0 5 7 19 42 ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=35780045 and t'... #...Verify (RA, DE) index on 'J/A+A/578/A45/table8' (73 records) no! ----[vizier] Stat=5 from 'update METAtab set morexplain='' where catid=35780045 a'... ----[vizier] Stat=62 from 'update METAcol set morexplain='' where catid=35780045 a'... #...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier #...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier #...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier #...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier #...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier #+++ Coordinates for table8.dat are COMPUTED: FK5 equinox=2000 ----Executed (0): vizin -confirm=y -popu 1928 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/A+A/578/A45/ReadMe #...(already cloned to NEWVIZ) #...(already cloned to VIZDB) ....Sourcing /home/cats/in/gl/c35780045groups.sql SET ERROR: table "c35780045groups" does not exist CREATE TABLE COMMENT SET SET ....Index i0c35780045groups (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c35780045t5.sql SET ERROR: table "c35780045t5" does not exist CREATE TABLE COMMENT SET SET ....Index i0c35780045t5 (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c35780045t6.sql SET ERROR: table "c35780045t6" does not exist CREATE TABLE COMMENT SET SET ....Index i0c35780045t6 (recno) CREATE INDEX ....Index i1 (_RAJ).... CREATE INDEX ....Index i2 (_DEJ).... CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c35780045t7.sql SET ERROR: table "c35780045t7" does not exist CREATE TABLE COMMENT SET SET ....Index i0c35780045t7 (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c35780045t8.sql SET ERROR: table "c35780045t8" does not exist CREATE TABLE COMMENT SET SET ....Index i0c35780045t8 (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/zz35780045.sql ----From vizAdd(X)count xcount -psql=N J/A+A/578/A45/groups J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} #===/home/cats/bin/xcount J/A+A/578/A45/groups J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} [4 args] #...asu -meta -meta.full -source=J/A+A/578/A45/groups -go -out.max=9 -source=J/A+A/578/A45/groups,table5,table6,table7,table8 | gawk -v c2var='N' -v args='Name=${Name}' -v go=1 -f /home/cats/bin/xcount.awk #===Items in list: 6 /* xcount: args='Name=${Name}' */ /* c1[1]=Name, c2[1]=Name, cv= */ /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(1) cols[1]=, c2:[1]=Name */ Update c35780045groups set N=0; /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(2) cols[2]=, c2:[1]=Name */ /* nt=2, cols[1]=Name_1, cols[2]=Name_1, t2=t2 */ Select Name_1, count(*) as N into temporary table t2 from viz7.c35780045groups group by Name_1; Update c35780045groups m set N=m.N+o.N from t2 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(3) cols[3]=, c2:[1]=Name */ /* nt=3, cols[1]=Name_1, cols[3]=Name_1, t2=t3 */ Select Name_1, count(*) as N into temporary table t3 from viz7.c35780045t5 group by Name_1; Update c35780045groups m set N=m.N+o.N from t3 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(4) cols[4]=, c2:[1]=Name,[2]= */ /* nt=4, cols[1]=Name_1, cols[4]=Name_1, t2=t4 */ Select Name_1, count(*) as N into temporary table t4 from viz7.c35780045t6 group by Name_1; Update c35780045groups m set N=m.N+o.N from t4 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(5) cols[5]=, c2:[1]=Name,[2]= */ /* nt=5, cols[1]=Name_1, cols[5]=Name_1, t2=t5 */ Select Name_1, count(*) as N into temporary table t5 from viz7.c35780045t7 group by Name_1; Update c35780045groups m set N=m.N+o.N from t5 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(6) cols[6]=, c2:[1]=Name,[2]= */ /* nt=6, cols[1]=Name_1, cols[6]=Name_1, t2=t6 */ Select Name_1, count(*) as N into temporary table t6 from viz7.c35780045t8 group by Name_1; Update c35780045groups m set N=m.N+o.N from t6 o where m.Name_1=o.Name_1; SET UPDATE 366 SELECT 356 psql:zz.log:10: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045groups m set N=m.N+o.N from t2 o where m.Nam... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:15: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045groups m set N=m.N+o.N from t3 o where m.Nam... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:20: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045groups m set N=m.N+o.N from t4 o where m.Nam... ^ HINT: You will need to rewrite or cast the expression. SELECT 39 psql:zz.log:25: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045groups m set N=m.N+o.N from t5 o where m.Nam... ^ HINT: You will need to rewrite or cast the expression. SELECT 73 psql:zz.log:30: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045groups m set N=m.N+o.N from t6 o where m.Nam... ^ HINT: You will need to rewrite or cast the expression. xcount -psql=N J/A+A/578/A45/table5 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} #===/home/cats/bin/xcount J/A+A/578/A45/table5 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} [4 args] #...asu -meta -meta.full -source=J/A+A/578/A45/table5 -go -out.max=9 -source=J/A+A/578/A45/groups,table5,table6,table7,table8 | gawk -v c2var='N' -v args='Name=${Name}' -v go=1 -f /home/cats/bin/xcount.awk #===Items in list: 6 /* xcount: args='Name=${Name}' */ /* c1[1]=Name, c2[1]=Name, cv= */ /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(1) cols[1]=, c2:[1]=Name */ Update c35780045t5 set N=0; /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(2) cols[2]=, c2:[1]=Name */ /* nt=2, cols[1]=Name_1, cols[2]=Name_1, t2=t2 */ Select Name_1, count(*) as N into temporary table t2 from viz7.c35780045groups group by Name_1; Update c35780045t5 m set N=m.N+o.N from t2 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(3) cols[3]=, c2:[1]=Name */ /* nt=3, cols[1]=Name_1, cols[3]=Name_1, t2=t3 */ Select Name_1, count(*) as N into temporary table t3 from viz7.c35780045t5 group by Name_1; Update c35780045t5 m set N=m.N+o.N from t3 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(4) cols[4]=, c2:[1]=Name,[2]= */ /* nt=4, cols[1]=Name_1, cols[4]=Name_1, t2=t4 */ Select Name_1, count(*) as N into temporary table t4 from viz7.c35780045t6 group by Name_1; Update c35780045t5 m set N=m.N+o.N from t4 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(5) cols[5]=, c2:[1]=Name,[2]= */ /* nt=5, cols[1]=Name_1, cols[5]=Name_1, t2=t5 */ Select Name_1, count(*) as N into temporary table t5 from viz7.c35780045t7 group by Name_1; Update c35780045t5 m set N=m.N+o.N from t5 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(6) cols[6]=, c2:[1]=Name,[2]= */ /* nt=6, cols[1]=Name_1, cols[6]=Name_1, t2=t6 */ Select Name_1, count(*) as N into temporary table t6 from viz7.c35780045t8 group by Name_1; Update c35780045t5 m set N=m.N+o.N from t6 o where m.Name_1=o.Name_1; SET UPDATE 45 SELECT 356 psql:zz.log:10: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t5 m set N=m.N+o.N from t2 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:15: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t5 m set N=m.N+o.N from t3 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:20: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t5 m set N=m.N+o.N from t4 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 39 psql:zz.log:25: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t5 m set N=m.N+o.N from t5 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 73 psql:zz.log:30: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t5 m set N=m.N+o.N from t6 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. xcount -psql=N J/A+A/578/A45/table6 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} #===/home/cats/bin/xcount J/A+A/578/A45/table6 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} [4 args] #...asu -meta -meta.full -source=J/A+A/578/A45/table6 -go -out.max=9 -source=J/A+A/578/A45/groups,table5,table6,table7,table8 | gawk -v c2var='N' -v args='Name=${Name}' -v go=1 -f /home/cats/bin/xcount.awk #===Items in list: 6 /* xcount: args='Name=${Name}' */ /* c1[1]=Name, c2[1]=Name, cv= */ /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(1) cols[1]=, c2:[1]=Name */ Update c35780045t6 set N=0; /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(2) cols[2]=, c2:[1]=Name */ /* nt=2, cols[1]=Name_1, cols[2]=Name_1, t2=t2 */ Select Name_1, count(*) as N into temporary table t2 from viz7.c35780045groups group by Name_1; Update c35780045t6 m set N=m.N+o.N from t2 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(3) cols[3]=, c2:[1]=Name */ /* nt=3, cols[1]=Name_1, cols[3]=Name_1, t2=t3 */ Select Name_1, count(*) as N into temporary table t3 from viz7.c35780045t5 group by Name_1; Update c35780045t6 m set N=m.N+o.N from t3 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(4) cols[4]=, c2:[1]=Name,[2]= */ /* nt=4, cols[1]=Name_1, cols[4]=Name_1, t2=t4 */ Select Name_1, count(*) as N into temporary table t4 from viz7.c35780045t6 group by Name_1; Update c35780045t6 m set N=m.N+o.N from t4 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(5) cols[5]=, c2:[1]=Name,[2]= */ /* nt=5, cols[1]=Name_1, cols[5]=Name_1, t2=t5 */ Select Name_1, count(*) as N into temporary table t5 from viz7.c35780045t7 group by Name_1; Update c35780045t6 m set N=m.N+o.N from t5 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(6) cols[6]=, c2:[1]=Name,[2]= */ /* nt=6, cols[1]=Name_1, cols[6]=Name_1, t2=t6 */ Select Name_1, count(*) as N into temporary table t6 from viz7.c35780045t8 group by Name_1; Update c35780045t6 m set N=m.N+o.N from t6 o where m.Name_1=o.Name_1; SET UPDATE 45 SELECT 356 psql:zz.log:10: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t6 m set N=m.N+o.N from t2 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:15: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t6 m set N=m.N+o.N from t3 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:20: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t6 m set N=m.N+o.N from t4 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 39 psql:zz.log:25: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t6 m set N=m.N+o.N from t5 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 73 psql:zz.log:30: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t6 m set N=m.N+o.N from t6 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. xcount -psql=N J/A+A/578/A45/table7 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} #===/home/cats/bin/xcount J/A+A/578/A45/table7 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} [4 args] #...asu -meta -meta.full -source=J/A+A/578/A45/table7 -go -out.max=9 -source=J/A+A/578/A45/groups,table5,table6,table7,table8 | gawk -v c2var='N' -v args='Name=${Name}' -v go=1 -f /home/cats/bin/xcount.awk #===Items in list: 6 /* xcount: args='Name=${Name}' */ /* c1[1]=Name, c2[1]=Name, cv= */ /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(1) cols[1]=, c2:[1]=Name */ Update c35780045t7 set N=0; /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(2) cols[2]=, c2:[1]=Name */ /* nt=2, cols[1]=Name_1, cols[2]=Name_1, t2=t2 */ Select Name_1, count(*) as N into temporary table t2 from viz7.c35780045groups group by Name_1; Update c35780045t7 m set N=m.N+o.N from t2 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(3) cols[3]=, c2:[1]=Name */ /* nt=3, cols[1]=Name_1, cols[3]=Name_1, t2=t3 */ Select Name_1, count(*) as N into temporary table t3 from viz7.c35780045t5 group by Name_1; Update c35780045t7 m set N=m.N+o.N from t3 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(4) cols[4]=, c2:[1]=Name,[2]= */ /* nt=4, cols[1]=Name_1, cols[4]=Name_1, t2=t4 */ Select Name_1, count(*) as N into temporary table t4 from viz7.c35780045t6 group by Name_1; Update c35780045t7 m set N=m.N+o.N from t4 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(5) cols[5]=, c2:[1]=Name,[2]= */ /* nt=5, cols[1]=Name_1, cols[5]=Name_1, t2=t5 */ Select Name_1, count(*) as N into temporary table t5 from viz7.c35780045t7 group by Name_1; Update c35780045t7 m set N=m.N+o.N from t5 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(6) cols[6]=, c2:[1]=Name,[2]= */ /* nt=6, cols[1]=Name_1, cols[6]=Name_1, t2=t6 */ Select Name_1, count(*) as N into temporary table t6 from viz7.c35780045t8 group by Name_1; Update c35780045t7 m set N=m.N+o.N from t6 o where m.Name_1=o.Name_1; SET UPDATE 39 SELECT 356 psql:zz.log:10: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t7 m set N=m.N+o.N from t2 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:15: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t7 m set N=m.N+o.N from t3 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:20: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t7 m set N=m.N+o.N from t4 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 39 psql:zz.log:25: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t7 m set N=m.N+o.N from t5 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 73 psql:zz.log:30: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t7 m set N=m.N+o.N from t6 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. xcount -psql=N J/A+A/578/A45/table8 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} #===/home/cats/bin/xcount J/A+A/578/A45/table8 J/A+A/578/A45/groups,table5,table6,table7,table8 -out.max=9 Name=${Name} [4 args] #...asu -meta -meta.full -source=J/A+A/578/A45/table8 -go -out.max=9 -source=J/A+A/578/A45/groups,table5,table6,table7,table8 | gawk -v c2var='N' -v args='Name=${Name}' -v go=1 -f /home/cats/bin/xcount.awk #===Items in list: 6 /* xcount: args='Name=${Name}' */ /* c1[1]=Name, c2[1]=Name, cv= */ /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(1) cols[1]=, c2:[1]=Name */ Update c35780045t8 set N=0; /* Table 'J/A+A/578/A45/groups' is viz7 . c35780045groups */ /* add_counts(2) cols[2]=, c2:[1]=Name */ /* nt=2, cols[1]=Name_1, cols[2]=Name_1, t2=t2 */ Select Name_1, count(*) as N into temporary table t2 from viz7.c35780045groups group by Name_1; Update c35780045t8 m set N=m.N+o.N from t2 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table5' is viz7 . c35780045t5 */ /* add_counts(3) cols[3]=, c2:[1]=Name */ /* nt=3, cols[1]=Name_1, cols[3]=Name_1, t2=t3 */ Select Name_1, count(*) as N into temporary table t3 from viz7.c35780045t5 group by Name_1; Update c35780045t8 m set N=m.N+o.N from t3 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table6' is viz7 . c35780045t6 */ /* add_counts(4) cols[4]=, c2:[1]=Name,[2]= */ /* nt=4, cols[1]=Name_1, cols[4]=Name_1, t2=t4 */ Select Name_1, count(*) as N into temporary table t4 from viz7.c35780045t6 group by Name_1; Update c35780045t8 m set N=m.N+o.N from t4 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table7' is viz7 . c35780045t7 */ /* add_counts(5) cols[5]=, c2:[1]=Name,[2]= */ /* nt=5, cols[1]=Name_1, cols[5]=Name_1, t2=t5 */ Select Name_1, count(*) as N into temporary table t5 from viz7.c35780045t7 group by Name_1; Update c35780045t8 m set N=m.N+o.N from t5 o where m.Name_1=o.Name_1; /* Table 'J/A+A/578/A45/table8' is viz7 . c35780045t8 */ /* add_counts(6) cols[6]=, c2:[1]=Name,[2]= */ /* nt=6, cols[1]=Name_1, cols[6]=Name_1, t2=t6 */ Select Name_1, count(*) as N into temporary table t6 from viz7.c35780045t8 group by Name_1; Update c35780045t8 m set N=m.N+o.N from t6 o where m.Name_1=o.Name_1; SET UPDATE 73 SELECT 356 psql:zz.log:10: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t8 m set N=m.N+o.N from t2 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:15: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t8 m set N=m.N+o.N from t3 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 45 psql:zz.log:20: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t8 m set N=m.N+o.N from t4 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 39 psql:zz.log:25: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t8 m set N=m.N+o.N from t5 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SELECT 73 psql:zz.log:30: ERROR: column "n" is of type tinyint but expression is of type bigint LINE 1: Update c35780045t8 m set N=m.N+o.N from t6 o where m.Name_1=... ^ HINT: You will need to rewrite or cast the expression. SET CLUSTER CLUSTER CLUSTER CLUSTER CLUSTER #***/home/cats/in/gl/zz35780045.sql returned status: 1 CONFIRM /home/cats/bin/confirm_no.nostdin Continue [N] (set by default)