| From: | Bill Cunningham <billc(at)ballydev(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Re: Schemas: status report, call for developers |
| Date: | 2002-04-30 17:45:45 |
| Message-ID: | 3CCED849.5040400@ballydev.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-30 18:23:45 | Re: Schemas: status report, call for developers |
| Previous Message | Tom Lane | 2002-04-30 17:31:30 | Schemas: status report, call for developers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-30 18:23:45 | Re: Schemas: status report, call for developers |
| Previous Message | Tom Lane | 2002-04-30 17:31:30 | Schemas: status report, call for developers |