Re: dropping template1
Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
To: <pgsql-general@postgresql.org>
Date: 2003-01-09T07:43:56Z
Lists: pgsql-general
On 9 Jan 2003 at 1:40, Thomas T. Thai wrote: > > On 9 Jan 2003 at 1:14, Thomas T. Thai wrote: > > > >> I'm using 7.3 and accidently created unnecessary functions and such in > >> 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? I meant just drop the functions you created. If you absolutely instist, shutdown postmaster, go to database dir, do a rm -rf there and doa initdb once again. Clean as slate.. Bye Shridhar -- Beam me up, Scotty, there's no intelligent life down here!