I am attempting this query in a postgresql snap:
"SELECT cm.id, cm.created_at, cm.context_id, cm.context_type, cm.conversation_id,
cm.author_id, cm.generated,c.udpated_at FROM canvas_le.conversation_messages cm
JOIN canvas_le.conversations c
ON cm.conversation_id = c.id
WHERE CAST('"+$max_dttm+"' AS TIMESTAMP) <
CAST(c.updated_at AS TIMESTAMP) AT TIME ZONE 'UTC';"
Where $max_dttm contains a mapped value incoming from a mapper snap. I am getting the following error:
“reason”:
“org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands
ignored until end of transaction block”
What does this error mean?