<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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster