Search Postgresql Archives

Re: Howto see template objects in PGAdmin3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, February 14, 2013 06:23, Guillaume Lelarge wrote:
> On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote:
>> PG-9.2
>> PGAdmin3-1.16.0

>>
>> I am attempting to do this from inside PGAdmin3 but I find that I no
>> longer see either template0 or template1 in the object tree.  Where
>> are they found?
>>
>
> You first need to check the "Show System Objects in the treeview"
> in the Options dialog. Then, they'll be available in the Databases
> node of the treeview.
>

Thank you.  With your help I now can view template1 in PGAdmin3.

I notice that the extension in question, plpgsql, has no owner in
template1 and yet I still receive this error when attempting to build
a new test database from a pgdump:

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

.  .  .

ERROR:  must be owner of extension plpgsql


Is this a bug?

-- 
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@xxxxxxxxxxxxx
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux