Re: Confusing terminology

From: "Arguile" <arguile(at)lucentstudios(dot)com>
To: "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Confusing terminology
Date: 2002-01-18 23:57:08
Message-ID: LLENKEMIODLDJNHBEFBOMEAMEAAA.arguile@lucentstudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen P. Berry 2002-01-19 00:24:33 Functions in C with Ornate Data Structures
Previous Message Roderick A. Anderson 2002-01-18 23:54:38 Re: Confusing terminology