Removing user-defined types & functions

From: Aleksey Dashevsky <postgres(at)luckynet(dot)co(dot)il>
To: PostgreSQL General Malining List <pgsql-general(at)postgreSQL(dot)org>
Subject: Removing user-defined types & functions
Date: 1998-07-20 14:20:06
Message-ID: Pine.LNX.3.96.SK.980720162630.27336C-100000@kesha.luckynet.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi!

I was playing with creating my own types and C-functions and have
notised that after one of my own types was removed functions that use it
became unexistent(i can't call them any more) . But still there are
all tuples in pr_proc that describes all that functions. So, my question
is: can I (or should I ) remove manually from pg_proc(and may be , some
other places) any mention about functions that haven't been deleted by
" drop function " operator but already unavailable 'cause type they use as
an argument type have been deleted.

Thanks.

Aleksey.

Browse pgsql-general by date

  From Date Subject
Next Message Gene Selkov, Jr. 1998-07-20 14:51:05 Re: [GENERAL] Recalling previous commands at the PSQL prompt
Previous Message Konstantinos Vassiliadis 1998-07-20 12:05:50 Forwarded mail....