From: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
---|---|
To: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Howto see template objects in PGAdmin3 |
Date: | 2013-02-14 15:06:59 |
Message-ID: | 8ac8420e5995b8ee0cdeabf1ded32510.squirrel@webmail.harte-lyne.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)Harte-Lyne(dot)ca
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-02-14 15:29:11 | Re: Query becomes slow when written as view |
Previous Message | Vick Khera | 2013-02-14 14:43:02 | Re: Installing Postgress 8.0.5 in Ubuntu 10.12 |