Обсуждение: ERROR: No such attribute or function 'oid'

Поиск
Список
Период
Сортировка

ERROR: No such attribute or function 'oid'

От
Jimmy Andersson
Дата:
When I'm doing "\d+ tablename" in psql I get the following message.
ERROR:  No such attribute or function 'oid'
I'm using version 7.1.3 of postgresql on linux 2.4.7-10

/jimmy



Re: ERROR: No such attribute or function 'oid'

От
Tom Lane
Дата:
Jimmy Andersson <jla@cention.se> writes:
> When I'm doing "\d+ tablename" in psql I get the following message.
> ERROR:  No such attribute or function 'oid'
> I'm using version 7.1.3 of postgresql on linux 2.4.7-10

I suspect you are using a 7.1 psql against a 7.2 server.  psql's \d
and related commands tend to be backend-version-specific; you'll need
to match psql and server versions.  Try "psql --version" and
"select version();" respectively to find what you have.
        regards, tom lane