| From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: createdb script bug in 7.3RC2? |
| Date: | 2002-11-27 17:18:38 |
| Message-ID: | 3DE4FE6E.8020104@mega-bucks.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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?
Jc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christian Imbeault | 2002-11-27 17:24:23 | Re: createdb script bug in 7.3RC2? |
| Previous Message | Szabó Roland | 2002-11-27 17:13:09 | Pg_dump uses up RAM and swap space |