"drop function" vs. "delete from pg_proc"

From: Bob Fischer <citibob(at)capu(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: "drop function" vs. "delete from pg_proc"
Date: 2001-01-24 04:49:10
Message-ID: 3A6E5EC6.8115086@capu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm considering writing some semi-automatic software that would create
and drop functions in a PostgreSQL database. I'm considering whether my
software must use the "drop function" command, or whether it can get
away with issuing "delete from pg_proc" commands. Is it safe to drop
functions by deleting from the pg_proc table?

Many database objects are held in tables (types, classes, functions,
etc). In general, is it safe or advisable to delete from the associated
table, rather than using the "official" drop command? What is the
difference between the two methods?

Thanks,
--- Bob Fischer

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-01-24 07:52:32 When replication?
Previous Message Tom Lane 2001-01-23 22:05:44 Re: Shared memory problem