On Tuesday 05 Nov 2002 2:32 pm, cristi wrote: > On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > >But - you have deleted the "refcursor" type which is not a good idea! If
> Ooo!!!! > Yes, I see... > You right. > > >If so, drop and recreate the database, restoring the data to it. If not, I > think you'll > >need to restore the template1 db - there's an article on > >techdocs.postgresql.org about this (byJosh IIRC). > > Would you give me the URL address for this article? > Please! It's "Adventures in PostgreSQL, Episode 1 by Josh Berkus" at http://techdocs.postgresql.org/ Loads of other good stuff there too. Might not be necessary though - if the template1 db contains the refcursor type definition then you just need to drop and recreate the problem database. -- Richard Huxton ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
