some tables do not exist

Question

some tables do not exist

AlaiY95 opened this issue 3 years ago · 4 comments

Hi,

I have loaded the dump file that was successful as I have 322 tables loaded into Postgres.

However when I run query "175. Combine Two Tables.sql" from the easy folder, I get the error
ERROR: relation "person_175" does not exist LINE 1: SELECT * FROM person_175; ^ SQL state: 42P01 Character: 15

Answer 1 · 2022-11-26T11:02:50.000Z

@AlaiY95 Apart from running the query, did you check whether that table got created or not?

Please check using information schema.

Please make sure you are querying the same database to which you've imported the dump

Answer 2 · 2022-11-26T11:14:19.000Z

@cM2908 can confirm that table was not created initially. It has tables person_182, person_196 but not person_175. Strange but I can live without doing the query. Just thought if there was an updated dump file

Answer 3 · 2022-11-26T11:22:54.000Z

@AlaiY95 I'll check and update.

Thanks though, appreciate it.

Answer 4 · 2022-11-29T12:16:36.000Z

@AlaiY95, Because this data has no records, I haven't created it. But the newer dump consists this table

Thanks