Guest User

Untitled

a guest
Oct 21st, 2019
111
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ProgrammingError: (psycopg2.ProgrammingError) column "name" does not exist
  2. LINE 4: (SELECT r FROM (SELECT name, value) r) )...
  3. ^
  4.  
  5. [SQL:
  6. SELECT collected
  7. , json_agg(row_to_json(
  8. (SELECT r FROM (SELECT name, value) r) )) AS stats
  9. FROM statistics
  10. WHERE date_part('hour', timezone('UTC'::text, collected)) = 0
  11. OR collected = (SELECT collected
  12. FROM statistics
  13. ORDER BY collected DESC
  14. LIMIT 1)
  15. GROUP BY collected
  16. ORDER BY collected DESC
  17. LIMIT %(limit)s]
  18. [parameters: {'limit': 1}]
  19. (Background on this error at: http://sqlalche.me/e/f405)
RAW Paste Data