Le jeudi 23 avril 2009 à 12:29:33, Jan-Peter Seifert a écrit : > [...] > in order to get a clean template1 I dropped and recreated it: > > UPDATE pg_database SET datistemplate = false WHERE datname = 'template1'; > > DROPDB -U postgres template1 > > CREATEDB -U postgres -T template0 template1 > > UPDATE pg_database SET datistemplate = true WHERE datname = 'template1'; > GRANT CONNECT ON DATABASE template1 TO public; > GRANT ALL ON DATABASE template1 TO postgres; > COMMENT ON DATABASE template1 IS 'default template database'; > > 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. -- 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
