Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id BFB81475A9D; Tue, 30 Apr 2002 13:46:33 -0400 (EDT) Received: from bush.ballydev.com (mail.ballydev.com [216.82.146.240]) by postgresql.org (Postfix) with ESMTP id 97D6E476025; Tue, 30 Apr 2002 13:46:21 -0400 (EDT) Received: (from mail@localhost) by bush.ballydev.com (8.9.3/3.1) id KAA12431; Tue, 30 Apr 2002 10:46:21 -0700 X-Authentication-Warning: bush.ballydev.com: mail set sender to using -f Received: from speedy.ballydev.com(10.2.200.27) by bush.ballydev.com via smap (V2.1/2.1+anti-relay+anti-spam) id xma012428; Tue, 30 Apr 02 10:46:14 -0700 Message-ID: <3CCED849.5040400@ballydev.com> Date: Tue, 30 Apr 2002 10:45:45 -0700 From: Bill Cunningham User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020326 X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-hackers@postgreSQL.org, pgsql-interfaces@postgreSQL.org Subject: Re: Schemas: status report, call for developers References: <21020.1020187890@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/1527 X-Sequence-Number: 22191 > >Here's an example of what's broken: > >test=# create schema foo; >CREATE >test=# create table foo.mytab (f1 int, f2 text); >CREATE >test=# create schema bar; >CREATE >test=# create table bar.mytab (f1 text, f3 int); >CREATE >test=# \d mytab > Table "mytab" > Column | Type | Modifiers >--------+---------+----------- > f1 | text | > f1 | integer | > f2 | text | > f3 | integer | > I would think this should produce the following: Table "bar.mytab" Column | Type | Modifiers --------+---------+----------- f1 | text | f1 | integer | Table "foo.mytab" Column | Type | Modifiers --------+---------+----------- f2 | text | f3 | integer | What do you think? - Bill Cunningham