Re: [GENERAL] strange error with temp table: pg_type_typname_nsp_index

2005-07-14 Thread Tom Lane
Janning Vygen [EMAIL PROTECTED] writes: PERFORM n.nspname ,c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname like 'pg_temp_%' AND pg_catalog.pg_table_is_visible(c.oid) AND

Re: [GENERAL] strange error with temp table: pg_type_typname_nsp_index

2005-07-14 Thread Janning Vygen
Am Mittwoch, 13. Juli 2005 16:04 schrieb Tom Lane: Janning Vygen [EMAIL PROTECTED] 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

[GENERAL] strange error with temp table: pg_type_typname_nsp_index

2005-07-13 Thread Janning Vygen
Hi, [i am using Postgresql version 8.0.3] yesterday i posted a mail regarding a function which calculates a ranking with a plperl SHARED variable. Today i ve got some problems with it: FEHLER: duplizierter Schlüssel verletzt Unique-Constraint »pg_type_typname_nsp_index« CONTEXT:

Re: [GENERAL] strange error with temp table: pg_type_typname_nsp_index

2005-07-13 Thread Tom Lane
Janning Vygen [EMAIL PROTECTED] 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