Le jeudi 23 avril 2009 à 14:48:29, Jan-Peter(dot)Seifert(at)gmx(dot)de a écrit :
> 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.
In response to
pgadmin-support by date
|Next:||From: Rainer Bauer||Date: 2009-04-24 19:48:20|
|Subject: pgAdmin not starting my job|
|Previous:||From: Jan-Peter.Seifert||Date: 2009-04-23 12:48:29|
|Subject: Re: system database flag?|