Code Completion Scope Broken

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:

`select *

from db2.schema_1.table_a`

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:

`select *

from db1.schema_1.table_a`

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??


Please sign in to leave a comment.