Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: type "temp_gc" already exists - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: type "temp_gc" already exists
Date
Msg-id 13266.1126791081@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: type "temp_gc" already exists  (Janning Vygen <vygen@gmx.de>)
Responses Re: ERROR: type "temp_gc" already exists
List pgsql-general
Tree view 
Janning Vygen <vygen@gmx.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

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: TSearch2 snowball version error
Next
From: "Peter Alberer"
Date:
Subject: Problem with 64-bit Postgres