Am Donnerstag, 15. September 2005 15:31 schrieb Tom Lane: > Janning Vygen <vygen@xxxxxx> writes: > > $ DROP TYPE temp_gc; > > ERROR: type "temp_gc" does not exist > > The temp schema is evidently not in your search path. You need > something like > drop type pg_temp_NNN.temp_gc; great support! great software! thanks a lot again! I managed it and now everything runs fine. kind regards janning ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend