Le jeudi 23 avril 2009 à 14:48:29, jan-peter.seif...@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.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support