Re: [HACKERS] Schemas: status report, call for developers - Mailing list pgsql-interfaces

<snip>

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