You certainly would get the long name trunaction notice if that's the problem. Unlike Oracle, Postgres doesn't have a "create or replace" function (or view) statement so you must delete old copies by hand (SQL92 doesn't have this, either).
Questions like this are probably better asked in the OpenACS 4 Design forum (which should really be named "design & implementation").
There's really no problem posting here but there may be folks so busy working on OpenACS 4 that they're only monitoring that forum, not the general forum, at least frequently. Also this will help keep all our OpenACS 4 Q's and A's in one place.
