> I created a new view called "clients2" with the same member tables as clients and it works I can query it.
>
> But due to the many hardcoded places that use "clients" view, I have to have "clients" view. So I tried to drop
clientsview but cannot
>
> #DROP view clients;
> ERROR: missing chunk number 0 for toast value 16538
I've no idea if this will work, but have you tried renaming the "clients" view and renaming "clients2" to "clients" to
replaceit?