Re: strange error with temp table: pg_type_typname_nsp_index - Mailing list pgsql-general

From Tom Lane
Subject Re: strange error with temp table: pg_type_typname_nsp_index
Date
Msg-id 27704.1121263496@sss.pgh.pa.us
Whole thread Raw
In response to strange error with temp table: pg_type_typname_nsp_index  (Janning Vygen <vygen@gmx.de>)
Responses Re: strange error with temp table: pg_type_typname_nsp_index
List pgsql-general
Janning Vygen <vygen@gmx.de> writes:
> I was just testing some configuration settings, especially increasing
> shared_buffers and setting fsync to false. And suddenly it happens 3 times
> out of ten that i get this error.

Could you put together a complete example --- that is a script someone
else could run to see this error from a standing start?

> It seems to me that setting fsync to false was not a good idea...

fsync per se is not relevant, unless maybe you were power-cycling the
machine.  Still it might be interesting to ask how you were stopping and
restarting the postmaster...

            regards, tom lane

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: INSERT INTO from a SELECT query
Next
From: Tom Lane
Date:
Subject: Re: Array as parameter for plpgsql function