Npgsql.PostgresException (0x80004005): 42P01: relation "ProductImages" does not exist

Question

Npgsql.PostgresException (0x80004005): 42P01: relation "ProductImages" does not exist

Ayobami Jimoh 1

Hey Guys. I am trying to read a list of products from the db using entity framework core.
Works on local environment but fails in production on heroku.
my db is in postgres

It happens when i try to "Include" the products images
Here is the error table

Also here are the entity declarations

i do code first approach

Here i try to get products so i include the images list .
if i don't include , no error but no images

@KranthiPakala-MSFT please if you can

Erland Sommarskog 122.7K Reputation points MVP Volunteer Moderator

2022-08-30T21:34:59.387+00:00

So maybe that tables does not exist in production?

In any case, you have tagged your question sql-server-general, but you are using Postgres which is a completely different product. I believe that there is a tag for the Azure service for Postgres, but else Postgres questions may be better asked in forums outside Microsoft.
Ayobami Jimoh 1 Reputation point

2022-08-30T22:27:51.003+00:00

honestly , i don't even understand why.
Maybe that's the problem , not sure how to check that
Thanks for the tip tho
Viorel 122.9K Reputation points

2022-08-31T07:20:51.347+00:00

Did you try to get some images separately from _context.ProductImages?

Also check if the database table contains the expected rows that correspond to your products.
Ayobami Jimoh 1 Reputation point

2022-08-31T14:13:48.66+00:00

Hey @Viorel , It doesn't work too.
I just realized i can't even view the tables on heroku.

But the products are loaded and user is loaded because i can log in
So i don't know where the data comes from

Your answer

Erland Sommarskog 122.7K Reputation points MVP Volunteer Moderator

2022-08-30T21:34:59.387+00:00

So maybe that tables does not exist in production?

In any case, you have tagged your question sql-server-general, but you are using Postgres which is a completely different product. I believe that there is a tag for the Azure service for Postgres, but else Postgres questions may be better asked in forums outside Microsoft.
Ayobami Jimoh 1 Reputation point

2022-08-30T22:27:51.003+00:00

honestly , i don't even understand why.
Maybe that's the problem , not sure how to check that
Thanks for the tip tho
Viorel 122.9K Reputation points

2022-08-31T07:20:51.347+00:00

Did you try to get some images separately from _context.ProductImages?

Also check if the database table contains the expected rows that correspond to your products.
Ayobami Jimoh 1 Reputation point

2022-08-31T14:13:48.66+00:00

Hey @Viorel , It doesn't work too.
I just realized i can't even view the tables on heroku.

But the products are loaded and user is loaded because i can log in
So i don't know where the data comes from

Share via

Npgsql.PostgresException (0x80004005): 42P01: relation "ProductImages" does not exist

Your answer