Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP

From: Marcin Kowalski <kowalski(at)datrix(dot)co(dot)za>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Date: 2001-03-29 08:35:06
Message-ID: 99us31$cvk$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general pgsql-hackers pgsql-sql

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karel Zak 2001-03-29 09:20:02 Re: [ADMIN] Re: Re: [PORTS] pgmonitor and Solaris
Previous Message Marcin Kowalski 2001-03-29 08:13:58 Re: pg_dump potential bug

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Mount 2001-03-29 08:52:05 Re: [JDBC] Possible large object bug?
Previous Message Marcin Kowalski 2001-03-29 08:13:58 Re: pg_dump potential bug

Browse pgsql-general by date

  From Date Subject
Next Message Peter Mount 2001-03-29 09:12:45 Re: fastpath error?
Previous Message Peter Mount 2001-03-29 08:29:28 Re: Bug in PostgreSQL JDBC Drive.

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Mount 2001-03-29 08:52:05 Re: [JDBC] Possible large object bug?
Previous Message Marcin Kowalski 2001-03-29 08:13:58 Re: pg_dump potential bug

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Mount 2001-03-29 09:09:02 Re: Calling Java from psql (was Re: requesting help)
Previous Message Phuong Ma 2001-03-29 08:25:30 inconsistent functionality with LIKE operator