#...dbdef =-SVIZIR -Ucds -P@cds4Viz viz7@VIZIR
ok not a XMM cat
====Catalog J/ApJ/799/155 already in VizieR-SVIZIR:
    J/ApJ/799/155|17990155|58|1|7
    J/ApJ/799/155|17990155|58|2|7
#===Items in list: 1
#...Popularity of catalog (J/ApJ/799/155): 697
setUCD -raw  /home/cats/J/ApJ/799/155/ReadMe > /tmp/viz33899.ucd
CONFIRM /home/cats/bin/confirm_no.nostdin
====Visit the 66 UCDs (in /tmp/viz33899.ucd): [N] (set by default)
====Database chosen for J/ApJ/799/155 = viz7@VIZIR (from default dbdef)
....Cleaning the /home/cats/in/gl directory
....keeping the list of UCDs as /home/cats/in/gl/UCDs
....Executing (METADB=metaviz@VIZIR, input file=/home/cats/J/ApJ/799/155/ReadMe):
(/usr/local/bin/vizin*)
CONFIRM /home/cats/bin/confirm_yes.nostdin
----Executing vizin -confirm=y -popu 697 -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/ApJ/799/155/ReadMe [Y] (set by default)
option confirm=y is set
#... servername=cdsarc.u-strasbg.fr port=5432
dbase=vizier             type=postgres (5)
---- 2 columns added from .status (0 VIRTUAL)
---- 3 columns (+1) added from .status (1 VIRTUAL)
---- 6 columns with LinkToNote
====There were 41 UCDs loaded from: /home/cats/in/gl/UCDs
use dbname=viz7@VIZIR
#...Change in METAtab(explain):
    
 => The target sample
----[vizier] Stat=1  from 'UPDATE METAtab set  morexplain = 'The target sample' wh'...
----[vizier] Stat=0  from 'DROP table c17990155t1'
#...Change in METAtab(explain):
    
 => Candidate companion parameters
----[vizier] Stat=1  from 'UPDATE METAtab set  morexplain = 'Candidate companion p'...
----[vizier] Stat=0  from 'DROP table c17990155t2'
----[vizier] Stat=0  from 'DELETE from METAqin where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAdig where catid = 17990155'
----[vizier] Stat=1  from 'DELETE from METAsed where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAobj where catid = 17990155'
----[vizier] Stat=35 from 'DELETE from METAcol where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell00 where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAlaf where catid = 17990155'
----[vizier] Stat=3  from 'DELETE from METAkwd where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcro where catid = 17990155'
----[vizier] Stat=2  from 'DELETE from METAtab where catid = 17990155'
----[vizier] Stat=60 from 'DELETE from METAnot where catid = 17990155'
----[vizier] Stat=3  from 'DELETE from METAmor where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell02 where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell03 where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell09 where catid = 17990155'
----[vizier] Stat=64 from 'DELETE from METAcell0a where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell0b where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell0c where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell0d where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAcell0e where catid = 17990155'
----[vizier] Stat=1  from 'DELETE from METAcat where catid = 17990155'
----[vizier] Stat=0  from 'DELETE from METAtimeCol where catid = 17990155'
----[vizier] Stat=1  from 'Update METAcat set status = status | 16 Where catid = 1'...
----[vizier] Stat=0  from 'Update METAcol set morid = 3 Where catid = 17990155 and'...
----[vizier] Stat=0  from 'Update METAcol set morid = 1 Where catid = 17990155 and'...
----[vizier] Stat=0  from 'Update METAcol set morid = 2 Where catid = 17990155 and'...
----[vizier] Stat=1  from 'select add_adc('J/ApJ/799/155', 'Stars, double and mult'...
----[vizier] Stat=1  from 'select add_adc('J/ApJ/799/155', 'Photometry, infrared')'...
----[vizier] Stat=1  from 'select add_adc('J/ApJ/799/155', 'Stars, masses');'
INFO:  ----wavelength-dependent exists for catalog: J/ApJ/799/155!
----[vizier] Stat=1  from 'select add_optical('J/ApJ/799/155');'
INFO:  ....set_kslot(3!): kslot was J/ApJ/799/155!; 255! keywords
INFO:  ----set_kslot(3!): kslot now J/ApJ/799/155!; 58! keywords
----[vizier] Stat=1  from 'select set_kslot('J/ApJ/799/155');'
----[vizier] Stat=1  from 'Update METAcat set catype = 2 Where catid = 17990155'
#=== 1 filters detected in J/ApJ/799/155/table1CONFIRM: <= [y]
----[vizier] Stat=1  from 'Update METAtab set flags=flags|256 where catid=17990155'...
.... Creating BCP file 'c17990155t1.bcp' (72 rows)         72 records.
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
++++DelK is ignored for photometry(ucd=phot.mag;arith.diff)
.... Creating BCP file 'c17990155t2.bcp' (130 rows)        130 records.
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=28 where catid=17990155 and t'...
----[vizier] Stat=1  from 'Update METAcol set dbtype=20 where catid=17990155 and t'...
----[vizier] Stat=2  from 'update METAtab set morexplain='' where catid=17990155 a'...
----[vizier] Stat=34 from 'update METAcol set morexplain='' where catid=17990155 a'...
#...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier
#...psql -hcdsarc.u-strasbg.fr -p5432 -Ucds -dvizier
#The following operations were generated by vizin
#From ReadMe: /home/cats/J/ApJ/799/155/ReadMe
#Into METAdb: metaviz@VIZIR
#     datadb: viz7@VIZIR
/*++++++++
  Clean up for catalog: 17990155
--------*/
#tab#1   loadate=0490272923s(2015-07-15T10:55:23) J/ApJ/799/155/table1
#tab#2   loadate=0490272923s(2015-07-15T10:55:23) J/ApJ/799/155/table2
/*------Clean up META tables--------*/

#==> Coordinate System of table1.dat: FK5 equinox=2000
	2MASS:Ks	in column: Ksmag
----Executed (0): vizin -confirm=y -popu 697 -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/ApJ/799/155/ReadMe
#...(already cloned to NEWVIZ)
#...(already cloned to VIZDB)
....Sourcing /home/cats/in/gl/c17990155t1.sql
SET
ERROR:  table "c17990155t1" does not exist
CREATE TABLE
COMMENT
SET
SET
....Index i0c17990155t1 (recno)
CREATE INDEX
GRANT
CLUSTER
....Sourcing /home/cats/in/gl/c17990155t2.sql
SET
ERROR:  table "c17990155t2" does not exist
CREATE TABLE
COMMENT
SET
SET
....Index i0c17990155t2 (recno)
CREATE INDEX
GRANT
CLUSTER
....Sourcing /home/cats/in/gl/zz17990155.sql
----From vizAdd(X)count
xcount -psql=No_1 J/ApJ/799/155/table1 J/ApJ/799/155/table2 -out.max=999 Name=${Name}
#===/home/cats/bin/xcount J/ApJ/799/155/table1 J/ApJ/799/155/table2 -out.max=999 Name=${Name} [4 args]
#...asu -meta -meta.full -source=J/ApJ/799/155/table1 -go -out.max=999 -source=J/ApJ/799/155/table2
| gawk -v c2var='No_1' -v args='Name=${Name}' -v go=1  -f /home/cats/bin/xcount.awk
#===Items in list: 2
/* xcount: args='Name=${Name}' */
/* c1[1]=Name, c2[1]=Name, cv= */
/* Table 'J/ApJ/799/155/table1' is viz7 . c17990155t1 */
/* add_counts(1) cols[1]=, c2:[1]=Name */
Update c17990155t1 set No_1=0;
/* Table 'J/ApJ/799/155/table2' is viz7 . c17990155t2 */
/* 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 No_1 into temporary table t2 from viz7.c17990155t2  group by Name_1;
Update c17990155t1 m set No_1=m.No_1+o.No_1 from t2 o where m.Name_1=o.Name_1;
SET
UPDATE 72
SELECT 48
UPDATE 48
xcount -psql=No_1 J/ApJ/799/155/table2 J/ApJ/799/155/table2 -out.max=999 Name=${Name}
#===/home/cats/bin/xcount J/ApJ/799/155/table2 J/ApJ/799/155/table2 -out.max=999 Name=${Name} [4 args]
#...asu -meta -meta.full -source=J/ApJ/799/155/table2 -go -out.max=999 -source=J/ApJ/799/155/table2
| gawk -v c2var='No_1' -v args='Name=${Name}' -v go=1  -f /home/cats/bin/xcount.awk
#===Items in list: 2
/* xcount: args='Name=${Name}' */
/* c1[1]=Name, c2[1]=Name, cv= */
/* Table 'J/ApJ/799/155/table2' is viz7 . c17990155t2 */
/* add_counts(1) cols[1]=, c2:[1]=Name */
Update c17990155t2 set No_1=0;
/* Table 'J/ApJ/799/155/table2' is viz7 . c17990155t2 */
/* 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 No_1 into temporary table t2 from viz7.c17990155t2  group by Name_1;
Update c17990155t2 m set No_1=m.No_1+o.No_1 from t2 o where m.Name_1=o.Name_1;
SET
UPDATE 130
SELECT 48
UPDATE 130
SET
CLUSTER
CLUSTER
#***/home/cats/in/gl/zz17990155.sql returned status: 1
CONFIRM /home/cats/bin/confirm_no.nostdin
Continue [N] (set by default)