> 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 clients view 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 replace it? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
