Re: Uninstall script errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Uninstall script errors
Date: 2006-03-07 16:12:00
Message-ID: 25483.1141747920@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> Having to change the types to shells, then drop the IO, then drop the
> type seems like a 'gotcha' and a bunch of needless extra work.

Depends. From pg_dump's perspective it's easier to do it that way,
because it drives all this from a reverse-dependency-order traversal
of the objects. If dropping the type magically makes the functions
go away then you'd want to somehow suppress the DROP commands for the
functions, and it's not clear how to do that, or what unpleasant
side-effects it might have (I can think of at least one place in
pg_restore that assumes all ownable objects have DROP commands in a
dump ...)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2006-03-07 16:26:35 Re: PostgreSQL Anniversary Summit, Call for Contributions
Previous Message Jim C. Nasby 2006-03-07 16:05:47 Re: Uninstall script errors