Re: Confusing terminology

"Roderick A. Anderson" wrote:
> 
> 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.

CREATE INDEX i_foo1 on foo(key);

ERROR: DefineIndex: relation "foo" not found

ALTER TABLE foo ADD COLUMN key integer;

ERROR: ALTER TABLE: column name "key" already exists in table "foo"

TRUNCATE TABLE foo;

ERROR:  Relation 'foo' does not exist

Mike Mascari
mascarm@mascari.com