Forum OpenACS Q&A: Re: myfirstpackage: ERROR: duplicate key violates unique constraint

Have you tried drop view mfp_notesi CASCADE?