Connect the deleted database by default in the created "query-2.psql" file after executing "Create Function Query..." from command palette

[v-xinda]

OS: All
Build Version: 20230205.1

Repro Steps:

1. Create a PostgreSQL account -> Create a database "Data01".
2. Delete the database "Data01".
3. F1 -> Click "Create Function Query..." -> Provide function name -> Select return type -> Enter.
4. Check the created query-2.psql file.

Expect:
Connect an existing database or show "connect to database" (Like Scrapbook.mongo file) in the created query-2.psql file.

Actual:

1. Connect the deleted database "Data01" in the created query-2.psql file.

2. An error occurs after clicking "Execute Query" in the created `query-2.psql` file.

More Info:
This issue also reproduces for the stored procedures query.

[alexweininger]

Is this a regression?

[v-xinda]

@alexweininger No, it's not a regression. This issue also reproduces on the current release build.

[JasonYeMSFT]

This is because deleting a postgres database requires first connecting to it, which will leave the deleted database in the cached connection data. A simple mitigation would be to always clear the connection after deleting a postgres database since we know it will always invalidate the current connection.