Re: system database flag?

[Guillaume Lelarge <guillaume(at)lelarge(dot)info>]

Le jeudi 23 avril 2009 à 14:48:29, Jan-Peter(dot)Seifert(at)gmx(dot)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.org
 http://dalibo.com