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
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 |