> Thanks, first of all it wasn't my mess, but someone elses.
>
> Secondly this worked however I was unable to use the same name, some
> remnants of the old database must have remained in pg_database.
>
> I couldn't even reindex it with postgres -O -P
Maybe try a full dump and reload now?
Chris