| From: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dropping template1 |
| Date: | 2003-01-09 13:22:49 |
| Message-ID: | 3E1D77A9.6070902@oli.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thomas T. Thai wrote:
>Shridhar Daithankar wrote:
>>On 9 Jan 2003 at 1:14, Thomas T. Thai wrote:
>>
>>>I'm using 7.3 and accidently created unnecessary functions and such i
>>>template1. Originally it had nothing added beyond the initial install
>>>(initdb). I would like to return it to the clean state.
>>
>>How about drop function?
>
> there are lots of functions and datatypes etc. is there an easier way?
Unless you did weird things, all functions and datatypes will be in
non-system schema's. Dropping and recreating the schema's will
implicitly drop the functions and datatypes as well. Don't forget to
vacuum freeze after that.
Jochem
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-01-09 14:04:02 | Re: How can I do this? |
| Previous Message | Chris Boget | 2003-01-09 13:08:15 | Re: How can I do this? |