Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f2UEcWK53756 for ; Fri, 30 Mar 2001 09:38:32 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2T8ebU31287; Thu, 29 Mar 2001 03:40:37 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f2T8Yi613303; Thu, 29 Mar 2001 03:34:44 -0500 (EST) (envelope-from news) From: Marcin Kowalski X-Newsgroups: comp.databases.postgresql.admin, comp.databases.postgresql.general, comp.databases.postgresql.questions, comp.databases.postgresql.sql Subject: Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP Followup-To: comp.databases.postgresql.admin Date: Thu, 29 Mar 2001 10:35:06 +0200 Organization: Datrix Solutions Lines: 37 Message-ID: <99us31$cvk$1@news.tht.net> References: <18053.985792976@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-admin@postgresql.org.pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200103/260 X-Sequence-Number: 1117 Hi Regarding my previous post, I just successfully created a unique index on pg_shadow. DON'T DO THIS!!! ------- CREATE UNIQUE INDEX shadow_index ON pg_shadow (usename) ------- I couldn't create at pg_shadow_index as the pg prefix is reserved for system tables. This BROKE the database. At least I can't connect anymore with a: ------- template1=# \c statements FATAL 1: Index 'pg_shadow_name_index' does not exist Previous connection kept template1=# ------- If I look at the error log I get : ------- ERROR: Illegal class name 'pg_shadow_index' The 'pg_' name prefix is reserved for system catalogs ERROR: Index 'pg_shadow_name_index' does not exist ERROR: SearchSysCache: recursive use of cache 23 ERROR: SearchSysCache: recursive use of cache 23 ERROR: SearchSysCache: recursive use of cache 23 ERROR: SearchSysCache: recursive use of cache 23 <-- quite psql here FATAL 1: Index 'pg_shadow_name_index' does not exist <-- restarted again FATAL 1: Index 'pg_shadow_name_index' does not exist FATAL 1: Index 'pg_shadow_name_index' does not exist ------- What can I do??? I've got a non-trivial amount of data that I cannot afford to lose!! HELP!.. Regards MArCin - Thanks