Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ProgrammingError: (psycopg2.ProgrammingError) column "name" does not exist
- LINE 4: (SELECT r FROM (SELECT name, value) r) )...
- ^
- [SQL:
- SELECT collected
- , json_agg(row_to_json(
- (SELECT r FROM (SELECT name, value) r) )) AS stats
- FROM statistics
- WHERE date_part('hour', timezone('UTC'::text, collected)) = 0
- OR collected = (SELECT collected
- FROM statistics
- ORDER BY collected DESC
- LIMIT 1)
- GROUP BY collected
- ORDER BY collected DESC
- LIMIT %(limit)s]
- [parameters: {'limit': 1}]
- (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement