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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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