| 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: | Whole Thread | Raw Message | 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 |