No idea how I got into this mess but it's driving me insane. On one Redshift instance I have several databases, let's call then db1 and db2, and they contain tables table_a within schema_1.
Somehow, if I'm connected to db1, I can still type:
and I don't receive any code errors because of it being out of the scope if the DB currently connected to. However, if I connect to db2 and write:
I DO get a code error, which is the desired behaviour and what was happening across all connections until about an hour ago....
How on earth do I change it back so that when connected to db1 I get the correct errors??