Skip site navigation (1) Skip section navigation (2)

Uninstall script errors

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Uninstall script errors
Date: 2006-03-01 03:19:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Several of the new uninstall scripts give errors, particularly those
that drop types and their support objects.  To see an example:

createdb foo
psql -d foo -f ltree.sql
psql -d foo -f uninstall_ltree.sql

A lot of the errors are due to DROP OPERATOR CLASS lines missing
the required USING clause; since that line fails so do subsequent
DROP OPERATOR and DROP FUNCTION lines because the operator class
still exists.  I've found a few other errors as well, such as a
CREATE TYPE line in uninstall_dblink.sql and a couple of DROP
FUNCTION lines in uninstall_btree_gist.sql for functions that were
never created.  I started to work on a patch but I wasn't sure how
to handle the chicken-and-egg situation of dropping a type and its
I/O functions.  Is there any way to do that other than DROP TYPE
CASCADE?  Should the uninstall scripts be doing that?

Michael Fuhr


pgsql-hackers by date

Next:From: SuvarnaDate: 2006-03-01 04:47:04
Subject: Re: bug in 7.3.2
Previous:From: Mark KirkwoodDate: 2006-03-01 02:18:21
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group