Skip site navigation (1) Skip section navigation (2)

Re: ENUM type script in pgAdmin 1.14.0

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: ENUM type script in pgAdmin 1.14.0
Date: 2011-09-26 19:11:00
Message-ID: 1317064260.2085.6.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgadmin-support
On Mon, 2011-09-26 at 09:33 +0200, bdmytrak(at)eranet(dot)pl wrote:
> My search_path is set to "$user", pg_temp

I tried, and it works for me. I see the public schema in the definition
of my type.

Best thing to do is open the query tool, and launch "show search_path".
And I'm pretty sure you'll find the public schema in it.

> so I think script should contain full definition regardles search_path settings (which could change during DB life cycle).

Yes and no. We could add an option to always view the schema, regardless
of the search_path setting. But one should be able to enable/disable
this behaviour.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-09-26 19:19:10
Subject: Re: foreign table->properties->options
Previous:From: Willy-Bas LoosDate: 2011-09-26 10:02:29
Subject: Re: pgadmin3 crash report

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group