0

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.

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
Dan Donaldson
  • 865
  • 1
  • 6
  • 15

0 Answers0