Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-04-30 18:23:45
Subject: Re: Schemas: status report, call for developers
Previous:From: Tom LaneDate: 2002-04-30 17:31:30
Subject: Schemas: status report, call for developers

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-04-30 18:23:45
Subject: Re: Schemas: status report, call for developers
Previous:From: Tom LaneDate: 2002-04-30 17:31:30
Subject: Schemas: status report, call for developers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group