SHARE
TWEET

Untitled

a guest Oct 21st, 2019 110 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top