On Fri, 2002-12-13 at 03:43, Philip Warner wrote: > At 02:56 AM 13/12/2002 -0500, Tom Lane wrote: > >if it's not the only column in Amy's table, Beth can drop her type > >and Amy's column along with it. > > I keep forgetting PG's inheritance features. In a non-inheritance system, I > would vote for forcing a one column table to be dropped. For PG, I think > you are right. >
Just out of curiosity, do any of the SQL specs deal with 0 column tables? I can't recall any dbms supporting a create table command that didn't require at least 1 column. Robert Treat ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
