On Fri, 18 Jan 2002, Arguile wrote:
> Roderick A. Anderson writes:
> > > ERROR: Relation 'foo' already exists
> >
> > Can a table named foo and a view named foo exist in the same database?
> >
> No. There's no reasonable way for the server to know which you mean when you
> execute a statement. This applies to tables, views, sequences, etc.
It was a rhetorical question (aka. smart-ass). My point was a table,
view, sequence, and their friends are all relations. Or at least to my
understanding the table and view are relations. And therefore Relation 'foo' already exists makes sense to me.
Best,
Rod
-- Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling" Marc Stiegler