Thread: Hiding built-in functions

Hiding built-in functions

From
Dave Lazar
Date:
Hi,

I remember at one time when I opened the functions node of the public
shema for a database, it was empty, save for the function I added to
the system.

At this time I am seeing a list of included functions from template1
or something in addition to ones I add.

Is there a way to hide the built-in functions so you can only see and
work on your own set of functions?

This would be a nice touch. Is there some other way to achieve this,
by creating the database differently?

Any insight most appreciated!!

Dave


Re: Hiding built-in functions

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Lazar
> Sent: 28 February 2005 17:38
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Hiding built-in functions
>
> Hi,
>
> I remember at one time when I opened the functions node of the public
> shema for a database, it was empty, save for the function I added to
> the system.
>
> At this time I am seeing a list of included functions from template1
> or something in addition to ones I add.
>
> Is there a way to hide the built-in functions so you can only see and
> work on your own set of functions?
>
> This would be a nice touch. Is there some other way to achieve this,
> by creating the database differently?

No, unfortunately there is no way to tell what is yours and what came
from template1. The best solution is to just try to use different
schemas to segregate things.

Regards, Dave.


Re: Hiding built-in functions

From
"Oisin Glynn"
Date:
It would be nice to have thse broken out or sperated into user and system 
functions or for pgAdminIII to allow you to create organisational folders 
within its tree view. I have resorted to naming all my functions zzfunc_xxx 
to keep them all together at the end of the list..

Oisin
----- Original Message ----- 
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "Dave Lazar" <hunkybill@gmail.com>; <pgadmin-support@postgresql.org>
Sent: Monday, February 28, 2005 3:59 PM
Subject: Re: [pgadmin-support] Hiding built-in functions


>
>
>> -----Original Message-----
>> From: pgadmin-support-owner@postgresql.org
>> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Lazar
>> Sent: 28 February 2005 17:38
>> To: pgadmin-support@postgresql.org
>> Subject: [pgadmin-support] Hiding built-in functions
>>
>> Hi,
>>
>> I remember at one time when I opened the functions node of the public
>> shema for a database, it was empty, save for the function I added to
>> the system.
>>
>> At this time I am seeing a list of included functions from template1
>> or something in addition to ones I add.
>>
>> Is there a way to hide the built-in functions so you can only see and
>> work on your own set of functions?
>>
>> This would be a nice touch. Is there some other way to achieve this,
>> by creating the database differently?
>
> No, unfortunately there is no way to tell what is yours and what came
> from template1. The best solution is to just try to use different
> schemas to segregate things.
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.306 / Virus Database: 266.5.2 - Release Date: 2/28/2005
>
> 



Re: Hiding built-in functions

From
"Dave Page"
Date:

> -----Original Message-----
> From: Oisin Glynn [mailto:me@oisinglynn.com]
> Sent: 01 March 2005 02:35
> To: Dave Page; Dave Lazar; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Hiding built-in functions
>
> It would be nice to have thse broken out or sperated into
> user and system
> functions

As I said, there is no was to tell the difference between a function
from a contrib module, or one created by you. The true system functions
(and other objects) are in the pg_catalog schema which is hidden away by
default.

> or for pgAdminIII to allow you to create
> organisational folders
> within its tree view.

Why not just create a separate schema for each logical part of your
system?

Regards Dave