Re: Dropping functions with missing argument types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ddkilzer(at)theracingworld(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dropping functions with missing argument types
Date: 2003-01-16 00:38:05
Message-ID: 9939.1042677485@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ddkilzer(at)theracingworld(dot)com writes:
> What is the best way to delete them? Am I able to simply identify and
> delete the corresponding rows from the PG_PROC table?

Yup, that should do it. You will need to be superuser to issue a delete
against pg_proc, but otherwise there's no reason not to.

> Are there any
> other system tables that I need to update if I delete rows from the
> PG_PROC table?

Not unless these were triggers or I/O functions, which I gather they're
not.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-16 00:40:22 Re: [GENERAL] gmake check error on HPUX
Previous Message Tom Lane 2003-01-16 00:32:17 Re: Problem handling timezones