Re: relation vs table...

Terrence Brannon writes:

> I don't understand why Postgres thinks I am creating a relation _and_ I
> don't know what it considers a relation to be.

In the context of relational databases, relation means the same thing as
table. Because of some implementation artifacts, PostgreSQL internally
treats tables, views, indexes, and sequences alike to some extent and
refers to all of them together as relations. So when you see an error
message telling you that a relation was not found, that means PostgreSQL
was looking for a table, a view, an index, or a sequence. This artificial
terminology isn't ideal, but it creates few problems in practice.

--
Peter Eisentraut peter_e(at)gmx(dot)net