[Bug]: Error upgrading pgai from <=v0.10.1 to a newer version

[smoya]

What happened?

Thanks to #826, I noticed there is an error upgrading from pgai v0.10.1 or earlier to v0.10.2 or later.

The view 'ai.vectorizer_status' changed its column layout in v0.10.2 to include 'v.name' as the second column and in prior versions the second column was 'source_table'.
Trying to redefine the view using create or replace view from an old format to the new one causes the following error "cannot change name of view column 'source_table' to 'name'".

Solution could be easy, just drop the view and recreate but didn't test it yet so can't say that would fix it either.

pgai extension affected

No response

pgai library affected

<=0.10.1

PostgreSQL version used

17

What operating system did you use?

Debian (official Postgres docker image)

What installation method did you use?

Not applicable

What platform did you run on?

Not applicable

Relevant log output and stack trace

How can we reproduce the bug?

1. `uvx pgai@0.10.1 install -d <your-db-connection-string>`
2. `uvx pgai@0.11.2 install -d <your-db-connection-string>`

Are you going to work on the bugfix?

None