Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0MLZ5l06911 for ; Tue, 22 Jan 2002 16:35:05 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0MLYlf28790; Tue, 22 Jan 2002 16:34:47 -0500 (EST) To: Fernando Nasser cc: Peter Eisentraut , pgsql-hackers@postgresql.org Subject: Re: RFD: schemas and different kinds of Postgres objects In-reply-to: <3C4DD909.F26FD0D1@redhat.com> References: <12239.1011661590@sss.pgh.pa.us> <3C4D8A39.FF79CDC4@redhat.com> <15339.1011716171@sss.pgh.pa.us> <3C4D96C5.80BBF764@redhat.com> <15638.1011718290@sss.pgh.pa.us> <3C4DCBDB.689D7201@redhat.com> <28199.1011732109@sss.pgh.pa.us> <3C4DD34F.CC4D8B6@redhat.com> <28557.1011734056@sss.pgh.pa.us> <3C4DD909.F26FD0D1@redhat.com> Comments: In-reply-to Fernando Nasser message dated "Tue, 22 Jan 2002 16:26:33 -0500" Date: Tue, 22 Jan 2002 16:34:47 -0500 Message-ID: <28787.1011735287@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/997 X-Sequence-Number: 17987 Fernando Nasser writes: > In the historical mode: look into schema B (=> not found), look into > ANY schema (finds it in A). Works as it is today. No, it doesn't work the same as today, because in that implementation both A and B can create the same tablename without complaint. It then becomes very unclear which instance other people will get (unless your "any" placeholder somehow implies a search order). The idea of being able to put an "any" placeholder into the search list is an interesting one, though. If we can resolve the ambiguity problem it might be a useful feature. I am a little troubled by the idea of placing "any" before the system schema (what if JRandomLuser creates a table named "pg_class"?) but it might be workable at the tail end of the path. regards, tom lane