From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Cc: | "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de> |
Subject: | Re: system database flag? |
Date: | 2009-04-23 12:01:17 |
Message-ID: | 200904231401.17815.guillaume@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2009-04-23 12:02:08 | Re: pgAmin 1.10 beta 2 and slony schema |
Previous Message | Willy-Bas Loos | 2009-04-23 11:51:07 | Re: pgAdmin hang on connection drop/reconnect |