Similar crossmatch service error: Error: relation "mydb.bcs3" does not exist LINE 1: copy (select * from mydb.bcs3) to stdout with csv heade... ^

Astro Data Lab Home

Astro Data Lab User Forum

220 views

Similar to the recent question but this time it mentions the csv header.

asked Jul 15, 2019 by pmanojlovic (150 points) | 220 views

1 Answer

Best answer

It's the same problem in the sense that these tables have invalid column names, in this case 'm*' and "e_m*". I've renamed these columns to be just 'm' and 'e_m' for your 'bcs', 'bcs2' and 'bcs3' tables so please try the crossmatch again.

answered Jul 16, 2019 by datalab (19,200 points)
selected Jul 17, 2019 by pmanojlovic

This solved it, but I also had to remove the hyphen (-) from the "LCS-CL" column. Cheers!

commented Jul 17, 2019 by pmanojlovic (150 points)

Similar crossmatch service error: Error: relation "mydb.bcs3" does not exist LINE 1: copy (select * from mydb.bcs3) to stdout with csv heade... ^

Please log in or register to add a comment.

Your answer

1 Answer

Please log in or register to add a comment.