Le jeudi 23 avril 2009 à 14:48:29, Jan-Peter.Seifert@gmx.de a écrit :
> Hello,
>
> Guillaume Lelarge wrote:
> > > However, when I view the properties of the new template1 in pgAdmin III
> >
> > it
> >
> > > isn't stated that it's a system database anymore. Is it because that
> > > the OID is different from 1 or is there a hidden flag? In pg_database I
> >
> > don't
> >
> > > see any significant difference from other servers' template1?
> > >
> > > Could you tell me, please?
> >
> > Because of the OID.
>
> Thank you very much for your quick reply. So there are no other 'glitches'
> or problems if recreating template1?
None that I know.
> I guess there's no way and it's not
> adviseable to change the OID back to 1?
>
I don't think it is adviseable. The only issue in pgAdmin will be to have this
catalog in the schemas node. I'm not sure this is really a big deal.
--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com