Somebody forgot to pin the built-in access methods

Started by Tom Lanealmost 10 years ago2 messageshackers
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Commit 473b93287 forgot a rather critical detail:

regression=# drop access method btree;
DROP ACCESS METHOD
regression=# select * from tenk1;
ERROR: cache lookup failed for access method 403

The fact that the command is restricted to superusers doesn't make
this a good idea.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Tom Lane (#1)
Re: Somebody forgot to pin the built-in access methods

Tom Lane wrote:

Commit 473b93287 forgot a rather critical detail:

regression=# drop access method btree;
DROP ACCESS METHOD
regression=# select * from tenk1;
ERROR: cache lookup failed for access method 403

Hah, nice one. Thanks for fixing.

--
�lvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers