Change owner of relation in PostgreSQL database
Community wiki answer:

A generic reason that affects those new to psql is forgetting the semicolon at the end of the command, so that it doesn't get executed. Otherwise your command looks good and should do what you want.