I have a Heroku App with a Postgres db, that uses a few pivot tables. When I ask psql to describe one of these, I get this:
XXXXXXXXXXXXXX::DATABASE=> \d tournament_player_pivot;
Table "public.tournament_player_pivot"
Column | Type | Collation | Nullable | Default
--------------+------+-----------+----------+---------
id | uuid | | not null |
tournamentID | uuid | | not null |
playerID | uuid | | not null |
But when I try to delete an entry or entries in this table:
:DATABASE=> delete from tournament_player_pivot where tournamentID = '22cc5253-1e70-4cd4-89ce-9f93f39f0725';
ERROR: column "tournamentid" does not exist
as shown, it fails. How can I get Postgres on Heroku to understand what I'm trying to do here? Changing it to lower case doesn't make any difference. If I reference the entry by the id, I can delete.