Re: Schemas: status report, call for developers

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-interfaces by date

  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