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

ERROR: No such attribute or function 'oid'

From
Jimmy Andersson
Date:
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'

From
Tom Lane
Date:
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