On Mon, May 28, 2018 at 8:43 PM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote:
> Hi, > > This issue has been already reported. https://redmine.postgresql.org > /issues/3361 > > For time being, you can set the 'Show system objects?' to True to list > down the template0 and template1. > This is just a work around, this issue will be fixed. > > You can find this setting through File > Preferences > Browser > Display . > Thanks, > Khushboo > > > On Mon, 28 May 2018, 20:28 Steve Hawes, <steve.ha...@tmlep.com> wrote: > >> Hi, >> >> >> >> I have just installed a clean copy of Postgres 10.4 and pgAdmin4 V3.0. >> When I try to create a new DB I cannot select template0 or template1 as the >> template because they do not appear in the list. If I execute: >> >> >> >> select datname,datistemplate from pg_database; >> >> >> >> I get the following output: >> >> >> >> datname datistemplate >> >> "postgres" false >> >> "template1" true >> >> "template0" true >> >> >> >> The templates exist but are not showing. >> >> >> >> How can I fix this please? >> >> >> >> *Version* >> >> 3.0 >> >> *Copyright* >> >> Copyright 2013 - 2018, The pgAdmin Development Team >> >> *Python Version* >> >> 2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM >> 8.0.0 (clang-800.0.34)] >> >> *Flask Version* >> >> 0.12.2 >> >> *Application Mode* >> >> Desktop >> >> *Current User* >> >> pgadm...@pgadmin.org >> >> >> >> Thanks >> >> Steve >> >> Steve Hawes​ >> CIO >> >> T: *020 3355 9796* <020%203355%209796> >> M: *+34 681 259 532* <+34%20681%20259%20532> >> E: *steve.ha...@tmlep.com* <steve.ha...@tmlep.com> >> W: *www.tmlep.com* <http://www.tmlep.com> >> A: >> *67 The Innovation Centre, University Road, Canterbury, Kent, CT2 7FG* >> <https://www.google.com/maps/place/47+The+Innovation+Centre,+University+Road,+Canterbury,+Kent,+CT2+7FG> >> [image: >> TMLEP | The Medico-Legal Experts Practice] <http://www.tmlep.com> >> Consider the environment. Do you really need to print this email? >> TMLE Limited is a company registered in England and Wales under number >> 08092743. The company's registered office is The Chestnuts, Brewers >> End, Takeley, Essex CM22 6QJ United Kingdom. >> >> This message contains confidential information and is intended only for >> the intended recipients. If you are not an intended recipient you should >> not disseminate, distribute or copy this e-mail. Please notify the sender >> immediately by e-mail if you have received this e-mail by mistake and >> delete this e-mail from your system. E-mail transmission cannot be >> guaranteed to be secure or error-free as information could be intercepted, >> corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. >> The sender therefore does not accept liability for any errors or omissions >> in the contents of this message, which arise as a result of e-mail >> transmission. If verification is required please request a hard-copy >> version. >> >> TMLEP may monitor email traffic data and also the content of emails for >> compliance purposes and to protect its business. >> >>
