Skip site navigation (1) Skip section navigation (2)

Re: strange error with temp table: pg_type_typname_nsp_index

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: strange error with temp table: pg_type_typname_nsp_index
Date: 2005-07-13 14:04:56
Message-ID: 27704.1121263496@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Janning Vygen <vygen(at)gmx(dot)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

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2005-07-13 14:08:01
Subject: Re: Array as parameter for plpgsql function
Previous:From: Google MikeDate: 2005-07-13 14:00:22
Subject: What's Popular for CMS and RAD with PHP/PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group