From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: createdb script bug in 7.3RC2? |
Date: | 2002-11-27 17:26:36 |
Message-ID: | 18708.1038417996@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> writes:
> As a follow-up I get an error when dropping plpgsql and then trying to
> re-create it ...
> $ psql JC -c "drop language plpgsql cascade"
> NOTICE: Drop cascades to function cancell_all_li()
> NOTICE: Drop cascades to trigger insert_invoices on table invoices
> NOTICE: Drop cascades to function update_invoice_price()
> NOTICE: Drop cascades to trigger update_invoice_li_price on table
> invoice_li
> NOTICE: Drop cascades to function max(date,date,date)
> DROP LANGUAGE
> $ createlang plpgsql JC
> ERROR: function plpgsql_call_handler already exists with same argument
> types
> createlang: language installation failed
> Once a language is dropped I should be able to re-add it no? Or isn't
> dropping it enough?
DROP LANGUAGE only drops the pg_language entry, not the call handler.
I think the dropdb script would drop the handler too, but you didn't
do that.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-27 17:32:41 | Re: createdb script bug in 7.3RC2? |
Previous Message | Jean-Christian Imbeault | 2002-11-27 17:24:23 | Re: createdb script bug in 7.3RC2? |