select clade_kingdom as kingdom, clade_division as division, clade_class as class, clade_subclass as subclass, clade_order as "order", clade_family as family, clade_genus as genus, clade_subgenus as subgenus, clade_section as section, clade_subsection as subsection, clade_species as species, clade_subspecies as subspecies, clade_series as series, clade_subseries as subseries, clade_stirps as stirps, clade_variety as variety, clade_form as form, clade_id as id, page.id as page_id, description_id, description_name_state as name_state, li.label as name_state_label, description_detail_spores, description_cap as cap, description_gills as gills,description_stem as stem, description_intro as intro, description_discussion as discussion, description_spores as spores, description_odor_taste as odor_taste, description_detail_discussion as detail_discussion, description_images as images, description_synonym as synonym, description_author as author, description_name, page.id as page_id, page.name as page_name, CASE WHEN trim(both ' ' from clade_subspecies::text )::text != ''::text THEN 'AAB' WHEN trim(both ' ' from clade_variety::text )::text != ''::text THEN 'AAC' WHEN trim(both ' ' from clade_form::text )::text != ''::text THEN 'AAD' ELSE 'AAA'::text END AS orderer_prime, CASE WHEN trim(both ' ' from clade_subspecies::text )::text in (NULL,'') THEN 'AAA'::Text ELSE trim(both ' ' from clade_subspecies::text )::text END as orderer_one, CASE WHEN trim(both ' ' from clade_subspecies::text )::text in (NULL,'') AND trim(both ' ' from clade_variety::text )::text in (NULL,'') THEN 'AAA'::Text WHEN trim(both ' ' from clade_variety::text )::text in (NULL,'') THEN 'AAB'::Text ELSE trim(both ' ' from clade_variety::text )::text END as orderer_two, CASE WHEN trim(both ' ' from clade_subspecies::text )::text in (NULL,'') AND trim(both ' ' from clade_variety::text )::text in (NULL,'') AND trim(both ' ' from clade_form::text )::text in (NULL,'') THEN 'AAA' WHEN trim(both ' ' from clade_variety::text )::text in (NULL,'') AND trim(both ' ' from clade_form::text )::text in (NULL,'') THEN 'AAB'::Text WHEN trim(both ' ' from clade_form::text )::text in (NULL,'') THEN 'AAC'::Text ELSE trim(both ' ' from clade_form::text )::text END as orderer_three from clade_description JOIN core.page page on (clade_description.description_page_id = page.id) LEFT JOIN (select * from core.list_item where list='Name States' ) li on (li.item = clade_description.description_name_state) WHERE page.active is TRUE and lower(clade_genus) = lower('amanita') order by species, orderer_prime, orderer_one, orderer_two, orderer_three ERROR: could not write block 1 of temporary file: No space left on device HINT: Perhaps out of disk space?