| From: | "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org> |
|---|---|
| To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Confusing terminology |
| Date: | 2002-01-19 17:58:34 |
| Message-ID: | Pine.LNX.4.10.10201190951590.17332-100000@tincan.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arguile | 2002-01-19 18:03:13 | Re: Confusing terminology |
| Previous Message | Tom Lane | 2002-01-19 17:36:31 | Re: pltlc and pltlcu problems |