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
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 |
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 |
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. |
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 |
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 |