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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Kowalski <kowalski(at)datrix(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Date: 2001-03-31 23:57:50
Message-ID: 28002.986083070@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general pgsql-hackers pgsql-sql

Marcin Kowalski <kowalski(at)datrix(dot)co(dot)za> writes:
> DON'T DO THIS!!!
> -------
> CREATE UNIQUE INDEX shadow_index ON pg_shadow (usename)
> -------

Indeed, trying to create nonstandard indexes on system catalogs is a BAD
idea. There probably ought to be a check to prevent you from trying.

> What can I do??? I've got a non-trivial amount of data that I cannot afford
> to lose!! HELP!..

I think you'd be OK if you could drop the index and then do

update pg_class set relhasindex = 'f' where relname = 'pg_shadow';

The trick is to be able to do that when the database is busted.
I think you may be able to do this if you restart in "ignore system
indexes" mode (use "-o -P" while starting postmaster). Worth a try
anyway.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-04-01 00:14:59 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message PostgreSQL newbie 2001-03-31 18:53:10 Re: Graphics GUI for PostgreSQL

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-04-01 00:14:59 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message pgsql-bugs 2001-03-31 23:11:16 segmentation fault in psql

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-01 00:14:59 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message Markus Mohr 2001-03-31 22:02:19 capitals in fieldnames

Browse pgsql-hackers by date

  From Date Subject
Next Message Johnny Cristensen 2001-04-01 00:11:49 ODBC Problems
Previous Message Johnny Cristensen 2001-03-31 23:32:14 Permissions on All Tables

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-04-01 00:14:59 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message Najm Hashmi 2001-03-31 16:33:13 TypeCreate: type links already defined