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

Re: Naive schema questions

From: <btober(at)computer(dot)org>
To: <JanWieck(at)Yahoo(dot)com>
Cc: <rory(at)campbell-lange(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Naive schema questions
Date: 2004-05-27 15:22:06
Message-ID: 65245.216.238.112.88.1085671326.squirrel@$HOSTNAME (view raw or flat)
Thread:
Lists: pgsql-general
> On 5/27/2004 7:15 AM, Rory Campbell-Lange wrote:
>
>> seems to suggest that the functions are schema specific.
>
> It is even better. The property that set's your "schema context" is
> called search_path. This contains a list of schema names. For an
> unqualified (schema name not explicitly given) object, be that a table,
>  sequence, view, function or whatever, the system looks in all those
> schemas in that particular order and uses the first found.

And where do tables created with "CREATE LOCAL TEMPORARY TABLE..." fit
into this, like if say a local temp table where created that has the same
name as an existing normal (i.e., not a local temp) table? And what if I
do an explicit DROP of the local temp table rather than relying on the
automatic, end-of-session clean-up? Is there any risk of losing the
normal table?

--Berend Tober




In response to

Responses

pgsql-general by date

Next:From: Ulrich MeisDate: 2004-05-27 16:25:16
Subject: Howto handle views/Rules Privileges
Previous:From: Laura VanceDate: 2004-05-27 14:21:07
Subject: Re: One more time on ONE-TO-MANY

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