Re: Confusing terminology - Mailing list pgsql-hackers

From Arguile
Subject Re: Confusing terminology
Date
Msg-id LLENKEMIODLDJNHBEFBOMEAMEAAA.arguile@lucentstudios.com
Whole thread Raw
In response to Re: Confusing terminology  ("Roderick A. Anderson" <raanders@tincan.org>)
Responses Re: Confusing terminology  ("Roderick A. Anderson" <raanders@tincan.org>)
List pgsql-hackers
Roderick A. Anderson writes:
>
> On Fri, 18 Jan 2002, Mike Mascari wrote:
>
> > What about "relation" vs. "table"?
> >
> > CREATE TABLE foo(key integer);
> >
> > ERROR: Relation 'foo' already exists
>
> Can a table named foo and a view named foo exist in the same database?
>
>
> Cheers,
> Rod

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.





pgsql-hackers by date:

Previous
From: "Roderick A. Anderson"
Date:
Subject: Re: Confusing terminology
Next
From: Laurette Cisneros
Date:
Subject: pg_dump question