Re: ERROR: type "temp_gc" already exists

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Janning Vygen <vygen(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: type "temp_gc" already exists
Date: 2005-09-15 13:31:21
Message-ID: 13266.1126791081@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Janning Vygen <vygen(at)gmx(dot)de> 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;

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Alberer 2005-09-15 13:56:23 Problem with 64-bit Postgres
Previous Message Alexander Neumann 2005-09-15 13:14:10 Strange Bug in exim4 postgresql lookup code or libpq?